final answer to run macro at certain time


A

as_sass

Hi!

I have searched this forum a number of times for a definite answer on
how to time macro execution, but have not found anything that helped.

Problem I have:

Run macro either at certain time(s) of day or in certain time interval
(whichever is easier).

Preferably using really easy code in which I understand what to
substitute to change the time interval, as I'm not too familiar with
the whole VBA thing.

Anybody got any (simple) ideas?

Thanks!

sass
 
Ad

Advertisements

Ad

Advertisements

J

JMB

You could use OnTime to run a macro at a specified interval. In this
example, "Test" will run "Test2" after 10 seconds. Then, when Test2 runs, it
will call the first macro and the process repeats.


Sub Test()
Application.OnTime Now + TimeValue("00:00:10"), "Test2"
End Sub

Sub test2()
MsgBox "Hello"
Call Test
End Sub
 

Top