Hi All,
Below is the code I use to trigger few macros in different time intervals. Currently I have to remember to close and open workbook at least once in 24 hours otherwise the macros will not perform very important tasks.
I was searching though forums and I was trying to implement things I found, but I couldn't get anything to work properly.
What should I add/change in order to have these macros repeated at given times everyday?
Private Sub Workbook_Open()
RaportShifts
Application.OnTime TimeValue("06:15:00"), "Send_Report_Email"
Application.OnTime TimeValue("10:00:00"), "Update_Links"
Application.OnTime TimeValue("14:15:00"), "Send_Report_Email"
Application.OnTime TimeValue("16:00:00"), "Update_Links"
Application.OnTime TimeValue("22:15:00"), "Send_Report_Email"
End Sub
Thx!
Below is the code I use to trigger few macros in different time intervals. Currently I have to remember to close and open workbook at least once in 24 hours otherwise the macros will not perform very important tasks.
I was searching though forums and I was trying to implement things I found, but I couldn't get anything to work properly.
What should I add/change in order to have these macros repeated at given times everyday?
Private Sub Workbook_Open()
RaportShifts
Application.OnTime TimeValue("06:15:00"), "Send_Report_Email"
Application.OnTime TimeValue("10:00:00"), "Update_Links"
Application.OnTime TimeValue("14:15:00"), "Send_Report_Email"
Application.OnTime TimeValue("16:00:00"), "Update_Links"
Application.OnTime TimeValue("22:15:00"), "Send_Report_Email"
End Sub
Thx!