b.hill2387
New Member
- Joined
- Mar 28, 2012
- Messages
- 38
I have multiple workbooks with multiple macros in each and an ontime sequence for every macro. I know that in a single workbook, if the ontime function schedules multiple macros to execute at the same moment they will execute in sequence (not simultaneously).
If I have the ontime function schedule all of these macros (25 workbooks, 15 macros per workbook) at 10:00a.m., is it possible to have excel execute them one at a time (in sequence)? I actually don't care about the specific order that they are executed in, just that it is one at a time. The reason I am not scheduling these to execute at different times is because the macros vary in how much time they need to complete every time they get executed. For this reason I would like to have the 375 macros (15 macros from each of the 25 workbooks) execute one at a time starting at a certain time.
If I have the ontime function schedule all of these macros (25 workbooks, 15 macros per workbook) at 10:00a.m., is it possible to have excel execute them one at a time (in sequence)? I actually don't care about the specific order that they are executed in, just that it is one at a time. The reason I am not scheduling these to execute at different times is because the macros vary in how much time they need to complete every time they get executed. For this reason I would like to have the 375 macros (15 macros from each of the 25 workbooks) execute one at a time starting at a certain time.