Pausing a Macro vs Stopping and Starting 3

[Bass71]

Hi;

I have to run a Do-Loop section of code every five minutes, for an 8 hour interval. I have the following code:

Application.Wait Now() + TimeSerial(0, 5, 0)

...although it works, the macro running continuously and I am afraid I increase the chance of crashing.

Is there a better way of executing this in which the macro rests for 5 minutes and then starts again?

thanks for your help...

 

[TonyJollans]

Hi Bass71,

Application.OnTime should do what you want. try something like ..

Application.OnTime EarliestTime:=Now() + TimeSerial(0, 5, 0), Procedure:="

ProcName

"

But do give yourself a way to stop it going forever.

Enjoy,
Tony

 

[krinid]

Tony,
Thanks again! One more neat trick you've taught me without my even asking. Another star for you. Btw: congratulations on the Tipmaster award.