Re: Excel 2004 Script Not Working
Re: Excel 2004 Script Not Working
- Subject: Re: Excel 2004 Script Not Working
- From: Paul Berkowitz <email@hidden>
- Date: Sat, 19 Jun 2004 20:44:40 -0700
As I said below, you have to quit your script editor after quitting the
first Excel and before opening the second Excel, then open the script editor
after opening the second Excel. You may even have to log out and log in
between Excels. (You don't have to do that with Script Debugger, but perhaps
you do have to with Script Editor.)
--
Paul Berkowitz
>
From: "Jack (Shekhar) Stoller" <email@hidden>
>
Date: Sat, 19 Jun 2004 23:22:59 -0400
>
To: <email@hidden>
>
Subject: Re: Excel 2004 Script Not Working
>
>
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.
_______________________________________________
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.