Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
call excel 2003 macro from command line
How do you call an excel macro from a command line.
For this instance I cannot use the AUTO_OPEN Macro and I need a way to open the excel workbook from windows scheduler and have the macro PERSONAL.XLR!testformat execute. I found out that in access you can use the /X (macro name) option but that does not work in excel Any help would be greatly appreciated. Thanks in advance. Keven |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
call excel 2003 macro from command line
Can you add a reference to the PERSONAL.XLR workbook in the
workbook you want to open, then, in the Workbook_Open procedure, add a call to testformat Kevin Beckham -----Original Message----- How do you call an excel macro from a command line. For this instance I cannot use the AUTO_OPEN Macro and I need a way to open the excel workbook from windows scheduler and have the macro PERSONAL.XLR!testformat execute. I found out that in access you can use the /X (macro name) option but that does not work in excel Any help would be greatly appreciated. Thanks in advance. Keven . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command line conversion from xls to xml - office 2003 | Excel Discussion (Misc queries) | |||
how do you assign a macro to a command button in Excel 2003 | Excel Discussion (Misc queries) | |||
Run Macro from Command line | Excel Discussion (Misc queries) | |||
How do I assign a macro to a command button in excel, office 2003 | Excel Discussion (Misc queries) | |||
Excel macro on a DOS command line | Excel Programming |