Schedule a macro to run at a certain time

**cmartin2459** · 04-30-2009, 11:07 AM

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

**royUK** · 04-30-2009, 11:25 AM

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

**karan** · 04-30-2009, 12:39 PM

Hi Martin,

Use this code:

Sub MacroName()

     Application.OnTime TimeValue("15:30:00"), "MacroName"
     'Your code comes here
     MsgBox ("Hello")

End Sub

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** · 04-30-2009, 01:19 PM

Karan, you need a date in there as well:

Sub MacroName()
    ' Your declarations here
    
    ' Schedule to run again tomorrow:
     Application.OnTime Date + 1 + TimeValue("15:30"), "MacroName"
     
     ' Your code here
End Sub