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: "Patrick D. Fox" <email@hidden>
- Date: Wed, 29 Jan 2003 10:29:23 -0800
Hi Steve:
Here is an example of the syntax I use in one of my scripts:
Evaluate ("'" & Name of ActiveWorkbook & "'" &
"!GeneratePivotTables.GeneratePivotTables()")
(note: no line break)
Patrick
>
Sorry to seem so dumb... but how can I use this command to run a macro?
>
I tried the test below but it wouldn't even compile.
>
>
Tell App "Excel"
>
Evaluate Macro "Macro1"
>
End Tell
>
>
Thanks,
>
>
Steve
>
>
On Wednesday, January 29, 2003, at 02:29 pm, David Glass wrote:
>
>
> Have you looked at 'Evaluate'?
>
_______________________________________________
>
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.