Running Macro at regular intervals.

Is there anyway in which I can run macro at regular intervals.

For example, Macro1 to be run every 180 minutes.

Thanks in advance

Hi

Have a look at the application.ontime method.

There are plenty of examples on the forum, as well as the excel vba help file.

rylo

Please Login or Register  to view this content.

Thanks for the info

Ok... I use the above code for running Macro2 every 1 hour. But I am having a problem here.. the Macro2 itself takes 3 - 5 mins (varies at different times) to run. Due to this the Macro2 doesnt run exactly at 1 hour. It runs at 63 - 65 minutes due to the time taken by macro2.

Is there anyway in which I can get it run exactly 1 hour which includes the macro running time also.

Any help regarding this would be much appreciated.

Plz let me know if you require any more info

The problem if I put the starttimer at the beginning is:

The starttimer will run exactly in 1 hour after the function is called thus running the Macro2. After this, immediately the Macro2 will repeat once again. (coz the code lies below it)

But I want this to run only once every 1 hour

Got it Thanks .. Checking this now :P

Works perfect

Thanks a lots