This auto run macro does not seems to run/repeat itself daily. I can't figure out why am I missing something? My end result should be that these reports run at the times listed on the macro every day 24/7. The spreadsheet will be on a computer that is never off.
Private Sub Workbook_Open()
Application.OnTime TimeValue("8:00:00"), "AThirdshift"
Application.OnTime TimeValue("8:00:00"), "BThirdshift"
Application.OnTime TimeValue("8:00:00"), "CThirdshift"
Application.OnTime TimeValue("8:00:00"), "DThirdshift"
Application.OnTime TimeValue("8:00:00"), "EThirdshift"
Application.OnTime TimeValue("8:00:00"), "FThirdshift"
Application.OnTime TimeValue("16:00:00"), "AFirstshift"
Application.OnTime TimeValue("16:00:00"), "BFirstshift"
Application.OnTime TimeValue("16:00:00"), "CFirstshift"
Application.OnTime TimeValue("16:00:00"), "DFirstshift"
Application.OnTime TimeValue("16:00:00"), "EFirstshift"
Application.OnTime TimeValue("16:00:00"), "FFirstshift"
Application.OnTime TimeValue("00:00:00"), "ASecondshift"
Application.OnTime TimeValue("00:00:00"), "BSecondshift"
Application.OnTime TimeValue("00:00:00"), "CSecondshift"
Application.OnTime TimeValue("00:00:00"), "DSecondshift"
Application.OnTime TimeValue("00:00:00"), "ESecondshift"
Application.OnTime TimeValue("00:00:00"), "FSecondshift"
End Sub
Bookmarks