use the windows task scheduler - set it to run the desired workbook at the
appropriate time.
in the workbook, make sure that you use the workbook open event to start
your sub, or have a sub name Auto_open

wrote in message
...
Hello,

I've got several macros which we would like to run in the middle of
the night - anyone got any suggestions of the best way of automatcally
running them? Use the OnTime method? problem is a macro still needs to
be run. Just wondering if a stored prodecdure on a sql server would be
capable of creating an event which could run the macro?


Any help much appreciated.

J