Running a macro every half hour
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
|