• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Scripting Excel X
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Scripting Excel X


  • Subject: Re: Scripting Excel X
  • From: Craig Sutherland <email@hidden>
  • Date: Fri, 10 May 2002 12:10:58 -0500

Eric,

This is listed as a bug with MS. The evaluate function is not working as it has before. I worked with mS back in December and they confirmed the problem, saying it could be addressed in an early 2nd quarter update.

Craig
On Monday, May 6, 2002, at 10:07 AM, Eric Phillips wrote:

I am running OS 10.1.3 with AS 1.7. I wrote a script to have Excel open a file and run an Excel macro using the

Evaluate "macro name"

statement. I got this statement by recording the action. The problem is when you run the script the macro does not run. So to fix that I took the time to convert the macro to AppleScript. My problem here is I want to refer to a cell in the form

select cell(rowcounter, 2)

The problem of doing this in AS is that I think it is looking at the cell coordinates as an array because it changes the () to {}. To get the cell coordinates into its preferred syntax I need to do the following

set cellref to "R" $ rowcounter & "C2" as text
select cell (cellref)

Am I missing something or do I need to add this extra step every time I need to change my cell reference? Is there a problem of calling Excel macros from AS?

Eric
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.

  • Follow-Ups:
    • Re: Scripting Excel X
      • From: Paul Berkowitz <email@hidden>
References: 
 >Scripting Excel X (From: "Eric Phillips" <email@hidden>)

  • Prev by Date: Re: Scrpting Excel X
  • Next by Date: RE: URL form data download into variable?
  • Previous by thread: Re: Scripting Excel X
  • Next by thread: Re: Scripting Excel X
  • Index(es):
    • Date
    • Thread