Re: How is the applescript support in Office 2004?
Re: How is the applescript support in Office 2004?
- Subject: Re: How is the applescript support in Office 2004?
- From: Paul Berkowitz <email@hidden>
- Date: Thu, 20 May 2004 12:37:44 -0700
On 5/20/04 10:48 AM, "Bill" <email@hidden> wrote:
>
David,
>
>
> From personal experience the support is amazing! (I'm biased) The
>
> dictionary is as big if not bigger than AppleScript Studio's
>
> dictionary and has a depth to it that is truly amazing.
>
>
>
>
Thanks for your reply :)
>
>
I tried the Office 2004 test drive, to my surprise, the following
>
script returns missing value, when cell A1 contains text "ABC"
>
>
tell application "Microsoft Excel"
>
tell Sheet 1 of document 1
>
get Value of Cell 1 of Row 1
>
end tell
>
end tell
>
-- missing value
>
>
nor set the value of any cell.
>
>
Well, is it related to test drive version?
The Test Drive for Office v. X removed all AppleScript and VBA. (Maybe they
were afraid you could turn off the 30-day limit!)
So I don't know - maybe Test Drive also has AppleScript stripped out. You
can tell by trying to open the Excel Dictionary in a script editor. If it's
not there you'll get a "this application is not scriptable" message. If it
is there, you'll see a new dictionary, If the script above was saved in
Excel X, it won't work in 2004. But if you type it anew, it should
re-compile without uppercase letters:
tell application "Microsoft Excel"
tell sheet 1 of document 1
get value of cell 1 of row 1
end tell
end tell
--> "ABC"
So it looks like AS was stripped out of the Test Drive, if your script still
compiles with the old terms.
BTW, one big difference in Excel scripting is that you can no longer use
R1C1 style references. (Aside from anything else, there were terrible bugs
in French and German Excel which had their own versions - "S1C1" etc. but
results were returned as RICI so it couldn't understand its own results!)
"A1" works: best is to use "absolute values "$A$1", i.e., using the column
and row denominators exactly as they appear in the worksheet.
--
Paul Berkowitz
_______________________________________________
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.