Expert Required

[ceemo]

I have a workbook containing 5 imported tables that i want to refresh
every hour at 20 minutes past the hour.

The below code will only refresh them once at 20 minutes past.


Plese can you help me adapt this code to keep refreshing tem every hour
at 20 past?




Option Explicit

Dim dNext As Date

Sub Auto_Open()

dNext = TimeSerial(Hour(Now) + IIf(Minute(Now) < 20, 0, 1), 20, 0)
Application.OnTime dNext, "refreshdata"
Workbooks(ActiveWorkbook.Name).RefreshAll
End Sub

Sub refreshdata()
dNext = TimeSerial(Hour(dNext) + 1, 20, 0)
Application.OnTime dNext, "refreshdata"
Workbooks(ActiveWorkbook.Name).RefreshAll
End Sub

Sub cancelTimer()
Application.OnTime dNext, "refreshdata", , False
End Sub
Edit/Delete Message

 

[Ron de Bruin]

Hi ceemo

See
http://www.cpearson.com/excel/ontime.htm