Place your code in the workbook_open routine and just open the file using task manager.
The code will run automatically.

--
Tim Williams
Palo Alto, CA


"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