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

--
Message posted from http://www.ExcelForum.com

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

--
Regards
Frank Kabel
Frankfurt, Germany


Hi Gurus,

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


---
Message posted from http://www.ExcelForum.com/

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

On Fri, 28 May 2004 16:52:31 -0500, jn1971
wrote:

Hi Gurus,

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


---
Message posted from http://www.ExcelForum.com/