You would store the macro code in Thisworkbook module as a Workbook_Open sub
then use task scheduler to start Excel with that workbook to open.

Or store the macro in a general module and name it Sub Auto_Open() and open
workbook using task scheduler as above.


Gord Dibben MS Excel MVP

On Sun, 19 Aug 2007 08:00:01 -0700, Dan wrote:

What is the best way to run an excel macro with the scheduler??
- is it possible to run the macro on file open?? how
- is it possible to run directly the macro as a VBA file??
- maybee another way??

thanks