Macro running at certain times
 

Is it possible to schedule macros to run at certain times?

Please note that I realise you could set a time in your
workbook (=NOW()) and use this number to be the variable
that will start the macros but if nothing is being
calculated in the spreadsheet then the time will not
update.

Is there a way to have the time update regardless if a
calculation is taking place or is there another way that
it could be done?


thanks
Mike

Macro running at certain times
 

Mike,

This is from VB Help.


This example runs my_Procedure at 5 P.M.

Application.OnTime TimeValue("17:00:00"), "my_Procedure"


Hope this is what you want

Charle

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

Macro running at certain times
 

yes,

thank you.



-----Original Message-----
Mike,

This is from VB Help.


This example runs my_Procedure at 5 P.M.

Application.OnTime TimeValue("17:00:00"), "my_Procedure"


Hope this is what you want

Charles


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

.