Scripting Excel X
Scripting Excel X
- Subject: Scripting Excel X
- From: "Eric Phillips" <email@hidden>
- Date: Mon, 06 May 2002 11:07:54 -0400
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.