Re: Excel 2004 Script Not Working
Re: Excel 2004 Script Not Working
- Subject: Re: Excel 2004 Script Not Working
- From: "Jack (Shekhar) Stoller" <email@hidden>
- Date: Sat, 19 Jun 2004 23:22:59 -0400
Paul,
Thanks for the advice. For some reason I still got the raw codes even with
Excel X open, but I moved the script up to my other computer and from there
it looked correct (and I could run them -- very timely for budgeting this
week). I'll work on fixing it up for Excel 2004 soon.
Jack
>
>
Date: Fri, 18 Jun 2004 21:00:44 -0700
>
Subject: Re: Excel 2004 Script Not Working
>
From: Paul Berkowitz <email@hidden>
>
To: AppleScript-Users <email@hidden>
>
>
The Excel dictionary in 2004 is completely different from X and earlier.
>
(It's also a lot bigger.) Have you looked at both of them?
>
>
The underlying "raw code" is utterly changed. but the "English" versions
>
aren't too different for terms that existed in X, except they're lower case
>
and have spaces between component words instead of squishing them together.
>
There are a few other differences.
>
>
So open your script while Excel X is open. Save it (or a copy) as Text - not
>
Script or application. Close the script. Quit Excel X. Quit your script
>
editor (essential). Open Excel 2004. Open your script editor. Open the Excel
>
2004 dictionary.
>
>
Now go through your text script (which looks the same as before aside form
>
being uncompiled text) and change all the SquishedTermsLikeThis into the
>
unsquished terms like this in the new 2004 dictionary. Check everything.
>
>
When done, compile. Find your errors (AppleScript will help you by selecting
>
the first one, one at a time) and fix them. In the end, when it compiles,
>
save it as Script or Application, as needed.
>
>
--
>
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.