Can I get a macro to run at a certain time of day?

N

Nick123

Hi

I have recorded a macro which I would like to run every 30 mins. Is there a
way I can get the macro to run automatically every 30 mins or at specific
times?

Any ideas on ways I can get it to do this?
 
A

aristotle

Something like this:

Sub TimerSet()
Application.OnTime Now + TimeValue("00:30:00"), "TimerSet"
YourMacro
End Sub

Regards,
A
 
Top