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: Fri, 18 Jun 2004 21:00:44 -0700
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
>
From: "Jack (Shekhar) Stoller" <email@hidden>
>
Date: Fri, 18 Jun 2004 23:43:14 -0400
>
To: <email@hidden>
>
Subject: Excel 2004 Script Not Working
>
>
Hi,
>
>
After installing Office 2004 I opened a large compiled script that moves
>
data between my FMP database and an Excel spreadsheet. All the Excel events
>
are now shown as raw event codes. For example:
>
>
tell application "Microsoft Excel"
>
>
+event XCELactv;
>
count the every +class cXLW;
>
set sheetCount to the result
>
>
If I write a new script, the similar statements compile and execute
>
properly:
>
>
tell application "Microsoft Excel"
>
>
activate
>
count the every worksheet
>
set sheetCount to the result
>
>
I still have both Excel X and Excel 2004 on the machine. Both are installed
>
in a disk partition that is not my boot volume (due to lack of space there).
>
I've tried copying the Excel 2004 app to the boot partition. I've tried
>
deleting Excel X from the other partition.
>
>
I also tried quitting Excel 2004 and launching Excel X. Now the small script
>
that did run with 2004 says it doesn't understand "Count every worksheet"
>
>
What can I do to put this script back in order? It's critical to my work. I
>
don't have the same problem with an Entourage script. That works fine.
>
>
Thanks,
>
>
Jack
>
_______________________________________________
>
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.