There is no way in Excel to designate a macro to run from the command line
or when the workbook is opened. You must use one of two macros for Excel to
run them when the workbook is opened. One is Sub Auto_Open. The other is
the Workbook_Open event handler in the ThisWorkbook module. Use either of
these and put your code in it.

Then use Scheduled Tasks to open the workbook.

--
Jim Rech
Excel MVP
"Tom" wrote in message
...
| Hi All,
|
| I am trying to automate a few Excel Macros, in order that
| I can used scheduled tasks to kick these macros off. For
| instance, I use the AutoExec function in Access a lot,
| and kick these off using scheduled tasks. I would like
| to replicate this for some Excel Macros.
|
| I have been told to use the Autorun function, with a Quit
| command at the end of the Macro to close the spreadsheet
| after the macro has run. However, I haven't got much
| Visual Basic knowledge and I can't get this to work. If
| anyone can help it will be very much appreciated.
|
| Tom
|