run an excelfile/macro automatically

J

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 :-
 
G

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
 
Top