You can't include in the command line a startup macro name. You
can use the Workbook_Open event procedure in the ThisWorkbook
code module to have code execute when the workbook is opened.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Maxwell2006" wrote in message
...
Hi,



I have an xls file that contains a VB macro named LOAD_DATA.
The macro loads some data into xls file.



I need to run LOAD_DATA macro every night through scheduled
tasks. Is there any command line to do that?



I there any better way to run a macro inside an excel file
through scheduled tasks?



Thank you,

Max