Schedule a macro to run at a certain time

[cmartin2459]

Is there a way to set a macro to automatically run at a certain time each day?

[royUK]

Look at the ONTIME method. lots of examples posted in the Forum

[karan]

Hi Martin,

Use this code:

Please Login or Register  to view this content.

If you run the above macro once, it will automatically run at the mentioned time again, i.e. 1530 hrs. But, Excel should be open at that time.

--Karan--

[shg]

Karan, you need a date in there as well:

Please Login or Register  to view this content.