Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting specific data from Date and time strings | Excel Discussion (Misc queries) | |||
Last Save date/time and User for a specific sheet in a shared work | Excel Programming | |||
counting instances of specific times in fields with date and time | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
time specific date input | Excel Programming |