|
Posted to microsoft.public.excel.programming
|
|
|
Running a macro every half hour
Thanks for the help!!!
-----Original Message-----
I have an example on my website
--
Rob van Gelder - http://www.vangelder.co.nz/excel
"Scott" wrote in message
...
If I want to run a macro every half hour, do I use the
OnTime method? This is what I have tried:
Dim KeepingTime As Boolean
Dim Times As Long
Times = 10
KeepingTime = True
Do While KeepingTime = True
Application.OnTime Now + TimeValue
("00:30:0"), "GetAll"
Times = Times - 1
If Times < 1 Then
KeepingTime = False
End If
Loop
Scott
.
|