Re: AppleScript and Microsoft Excel
Re: AppleScript and Microsoft Excel
- Subject: Re: AppleScript and Microsoft Excel
- From: Doug McNutt <email@hidden>
- Date: Fri, 30 Aug 2002 08:36:50 -0600
At 23:13 -0400 8/29/02, Keith McDaniel wrote:
>
I have been successful in writing a simple script that captures 6 variables of data. Can anyone help me set this script to run only the first time you open an excel spread sheet,
It's fairly easy to set up a macro in Visual Basic for Applications (VBA) that will run only as a workbook is opened. Look for Workbook_Open in the VBA help files. But, after saying that, I don't know how to ask VBA to call an AppleScript. VBA can display a "form" requesting information and of course it can populate cells.
Consider starting your AppleScript first and having it ask - er tell - Excel to open the workbook. After waiting for the open to finish the script can populate the cells and quit. The script can also check to be sure the specified workbook is not already open.
--
--> If you are presented a number as a percentage, and you do not clearly understand the numerator and the denominator involved, you are surely being lied to. <--
_______________________________________________
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.