Re: Run a macro in Excel 2004
Re: Run a macro in Excel 2004
- Subject: Re: Run a macro in Excel 2004
- From: Doug McNutt <email@hidden>
- Date: Mon, 7 Jun 2010 10:23:20 -0600
Title: Re: Run a macro in Excel 2004
At 19:34 +0700 6/7/10, L R K Perera wrote:
>Can someone teach me how to write the code to run an Excel
2004 macro from within a script? The
>macro I recorded runs in Excel. I am unable to find the
exact scripting command to run it through a
>script. I am using Tiger (10.4.11).
In Excel 2001 on this OS 9 machine there are:
Evaluate: This event passes one or a list of Excel functions
and/or macros, which Excel then evaluates and/or executes.
Evaluate anything -- Either one
function/macro to evaluate/execute, or a list of functions/macros.
Result: anything
-- If passed one function/macro, Excel returns one value (the
result of evaluating the function or executing the macro statement).
If passed a list, Excel returns the list.
RunAutoMacros: Run some auto macros on a given workbook
RunAutoMacros Workbook -- the workbook
whose auto macros to run
Which
xlAutoOpen/xlAutoClose/xlAutoActivate/xlAutoDeactivate -- which
auto macros to run
--
--> The best programming tool is a soldering iron
<--
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden