The Excel 2004 battle continues - An Answer
The Excel 2004 battle continues - An Answer
- Subject: The Excel 2004 battle continues - An Answer
- From: James Murphy <email@hidden>
- Date: Mon, 28 Nov 2005 21:06:16 -0800
Bob Poland wrote the following:
set xdatas to {}
tell application "Microsoft Excel"
activate
set xdatas to value of range "R1000C1:R1000C14"
display dialog "xdatas = " & xdatas
end tell
Note: Excel 2004 no long supports R1C1 ranges so if I am reading you old script correctly The following script should do the trick
set xdatas to {}
tell application "Microsoft Excel"
activate
set xdatas to value of range "A1:A14"
display dialog "xdatas = " & xdatas
end tell
Range arguments are always strings. That should help
Jim "Murf" Murphy
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden