I've seen a lot of traffic around running macro's on a clock at regular intervals. But what if I want to run a Macro (Macro1) at 8:55, 9:55, 11:55, 12:55, 13:55, 16:55 and another Macro (Macro2) at the top of each of those hours? The string of times is not consecutive, so I have built a table to define the release times. At each of these times I need to run a macros, and I'm not sure where to begin.
Thanks in advance!
Use another macro to schedule those macros. In the same workbook / same module, use code like this, that you run before 8:55 AM:
Please Login or Register to view this content.
Bernie Deitrick
Excel MVP 2000-2010
I would need some code to construct this Macro, as the list can vary. Today it may be 3 times, tomorrow it may be 50. So based on user input the macro would be constructed... again something new for me.
Create a table, on a sheet named "Schedule" with the macro names in row 1 starting in column A. Below each macro name, place the required times to run them, in whatever time format you prefer. If you don't want to run a specific macro that day, just leave all the cell below its name blank.
Then use this macro:
Please Login or Register to view this content.
Last edited by Bernie Deitrick; 06-25-2014 at 01:14 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks