Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a macro from the command line
How do you use the command line to run a specific macro on a specific xls
file? In Word, I use this syntax: winword FileName /mMacroName But doing this in Excel opens Excel but does not run the macro: excel FileName /mMacroName -- Karel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a macro from the command line
Excel does not support naming a macro to run from the command line. The
only macro that runs automatically with a workbook opening is its WorkBook_Open event handler and a sub named Auto_Open if one exists. If these routines could find the name of the macro you wanted run they could run it. Maybe in an INI file or in the registry? I've never had to do this. -- Jim Rech Excel MVP "Czech" wrote in message ... | How do you use the command line to run a specific macro on a specific xls | file? | | In Word, I use this syntax: | | winword FileName /mMacroName | | But doing this in Excel opens Excel but does not run the macro: | | excel FileName /mMacroName | | -- | Karel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run Macro from Command line | Excel Discussion (Misc queries) | |||
Running a Command Button from a different sheet | Excel Programming | |||
call excel 2003 macro from command line | Excel Programming | |||
Command line parameters into a macro | Excel Programming | |||
Excel macro on a DOS command line | Excel Programming |