run an excelfile/macro automatically
 

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

run an excelfile/macro automatically
 

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/

run an excelfile/macro automatically
 

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/