Re: Run a Macro in MS Excel (v.X)
Re: Run a Macro in MS Excel (v.X)
- Subject: Re: Run a Macro in MS Excel (v.X)
- From: Steve Savery <email@hidden>
- Date: Thu, 30 Jan 2003 11:52:46 +0000
Paul and All
Thanks to everyone for the help posted. The code submitted by Paul
below works perfectly.
Now I can really start automating tasks left, right and center!
Steve
On Wednesday, January 29, 2003, at 06:37 pm, Paul Berkowitz wrote:
For one thing, you need to get the name of the app correct. You need
the
name of the open workbook followed by "!" and the true call to the
Macro as
you would do in VBA. In VBA macro names (subs) cannot have spaces, and
must
have parentheses.
tell app "Microsoft Excel"
Evaluate "Workbook1!Macro1()"
end tell
_______________________________________________
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.