Auto Refresh Data (Time Based)

[treeantz]

hi all, just wondering if it is possible to program Excel to refresh a web query connection? I have the following code and it works but it only refreshes when I click or open the workbook.

Private Sub Worksheet_Activate()
ActiveWorkbook.RefreshAll
End Sub

I'm hoping to program Excel to refresh the workbook at 12:00PM daily.

Thanks in advance.

 

[JoeMo]

You can use the OnTime Method:
http://www.cpearson.com/Excel/OnTime.aspx