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?

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

--
HTH

Bob Phillips

"Nick123" wrote in message
...
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?

Something like this:

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

Regards,
A

"Nick123" wrote:

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?