Re: passing info back
Re: passing info back
- Subject: Re: passing info back
- From: Paul Berkowitz <email@hidden>
- Date: Thu, 20 Mar 2003 21:01:29 -0800
On 3/20/03 8:23 PM, "Wesley Furgiuele" <email@hidden> wrote:
>
- For basic formatting and copy/paste, is it better to write Excel
>
macros and have the AppleScript launch those macros, or can I just use
>
AppleScript reliably to access and manipulate the spreadsheet contents?
Excel's AppleScripting is excellent, if you can figure out what to do, since
the dictionary has nothing but the syntax - no explanations. However, the
terms and parameters are basically identical to their VBA equivalents, so
just open VB Editor and check the Help there, which is excellent. The
advantage of doing it by AppleScript is that you can avoid the dialog as to
whether you want to enable or disable the macros every time the spreadsheet
is opened (or if you try to avoid that one by including the macro in a
document in the Startup folder the possibility that it might get lost when
doing a reinstall or update). Also the term for running Excel macros -
Evaluate - wasn't working in Office 10.0, so you'd have to be sure you had
installed SR-1 or the latest update 10.1.2 (which I guess you should do
anyway. as long as there's no chance it would ever be needed in Excel French
or German which have a bug that makes AppleScript unusable there for most
scripts.
--
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.