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

[Guest]

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?

 

[Bob Phillips]

You need Ontime. See http://www.cpearson.com/excel/ontime.htm

 

[Guest]

Something like this:

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

Regards,
A