Re: Scripting Excel X
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.