Help!
I am trying to run a macro at 0330 and 0430 every weekeday. The following code is on the "ThisWorkbook" object in the workbook I leave open. It runs the day I open the spreadsheet but does not run on any subsequent day. I am using excel 2016.
Note: I am not able to use a scheduled task as IT has locked that functionality and will not allow me to schedule a windows task.
Private Sub Workbook_Open()
If Weekday(Now, vbMonday) < 6 Then 'check if weekday is < 6, starting by Monday with 1 (Sat = 6, Sun = 7)
Application.OnTime TimeValue("03:30:00"), "UpdateShared"
Application.OnTime TimeValue("04:30:00"), "Extract_Reformat"
End If
End Sub