Run macro every x minutes

[govi]

Hi there,

I have a macro with a bunch of code.

I want it to run every 5 minutes.

Any suggestions?

Thanks!
govi

 

[Marc L]

​

Hi,​

​

see Application.OnTime method in the VBA integrated help …​

​

 

[SirJB7]

Hi, govi!
Despite of giving a look to the following link you could start thinking on increasing memory, switching to a faster processor, or the best of all: deleting at least half of the bunch of code.
http://chandoo.org/forum/threads/he...elapsed-time-with-5minute-visual-alarms.10418
Regards!

 

[govi]

Hi Marc L and SirJB7,

I figured it out, thanks for your tips.

govi

 

[SirJB7]

Hi, govi!
Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.
Regards!