Hi

You could use a Workbook_Open event to call OnTime method. Of course the
workbook has to be open.

Hopes this helps.

//Per

skrev i meddelelsen
...
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