run an excelfile/macro automatically

[jn1971]

Hi Gurus,

I created a macro in an excel spreadsheet97. Is there any coding wa
that I could run periodically the macro/spreadsheet automatically no
using the window task schedule . Any suggestion/code is greatl
appreciated. Thanks Jeanie :-

 

[Frank Kabel]

Hi
you may use the OnTime method for this. See:
http://www.cpearson.com/excel/ontime.htm

 

[Gord Dibben]

The macro can run when you open the workbook, but you have to start Excel
somehow.

If Excel is not running, Task Scheduler must be used to start Excel from a
shortcut to your workbook with the Auto_Open macro.

Frank's reference to the OnTime method assumes Excel is already running.

Gord Dibben Excel MVP