View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jk9533 jk9533 is offline
external usenet poster
 
Posts: 13
Default Schedule Macro doesn't seem to run any suggestions

Below is a scheduled macro to run everyday at 5:00 am. It doesn't seem to be
working. Does anybody know how to fix?

Sub Schedule()
Application.OnTime EarliestTime:=TimeValue("5:00 AM"),
Procedu="RefreshDaily", Schedule:=True
End Sub

Thanks