I don't think that the workbook has to be open for this. Excel will find the
workbook with that ontime macro and open it if it needs to.

But the excel application does have to be kept open.

Per Jessen wrote:

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

--

Dave Peterson