And to add to Patrick's response...

Make sure your security settings are set to allow macros to run. You wouldn't
want to check the next morning to find that excel is prompting you to see if
macros should be enabled.



Patrick Molloy wrote:

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

--

Dave Peterson