I have a macro that needs to run monday through friday at both 5 AM and 7 PM. Since I know very little about VBA my plan was to simply run it as stated below. However I have realized that the data I need will updated on friday night but will not updated until monday morning. Is there any way that I can specify to pause if the first part of the Macro runs on friday and wait for the second part to run on monday? I appreciate any help I can get with this. Thank you!


Private Sub Workbook_Open()
    Application.OnTime TimeValue("19:00:00"), "CopyClose"
    Application.OnTime TimeValue("05:00:00"), "CopyOpen"
End Sub