Run on specific time/date?
 

Hello!

I'm hoping someone can help me here. I have a macro that is set to run on open...it kicks off another macro at a certain time. For the purpose of testing, I have the macro it kicks off set to refresh (nothing fancy). It looks like this:

Private Sub Workbook_Open()
Application.OnTime TimeValue("16:30:00),"Update"
End Sub

Sub Update()
ThisWorkbook.RefreshAll
End Sub

However, what I would like to do is have it set for a time and a date - I can't figure out how to do the date part. I'd like to leave this open and have it kick off certain macros at certain dates/times while I'm away. Does that make sense? So instead of just a time (16:30 today), I may want it to run at 4:30 on Friday etc.

Can anyone assist? I appreciate your help in advance.

J