Hi all, we have a document that is updated when you click a button. I would like it to update every hour, is there a way I can edit the below code to do so? (The code is from the button you press to re-fresh the data).
Sub Refresh()
Application.ScreenUpdating = False
Call Download_Spool_List
If Sheets("Sel").Range("B12").Value = 1 Then
Call Data_Sheet_Format
Call Data_Sheet_Update
Call Update_Data
Sheets("Sel").Range("B4").ClearContents
Sheets("Sel").Range("B5").ClearContents
End If
Sheets("Sel").Range("B12").Value = 0
Sheets("Rate Sheets").Select
Range("C2").Select
ActiveWorkbook.Save
Sheets("Front Sheet").Select
Range("D8").Formula = "=Today()"
Range("D8") = Range("D8").Value
End Sub
Thanks in advance. Matt
Bookmarks