Running Multiple Macros Simultaneously

[450nick]

Hi there,

I have workbook which each hour triggers a series of macros to run for a particular project (there are several), which creates metrics and reports and stuff. This process takes around 15-20 minutes depending on which project it is running on and at the end of the process, the workbook auto closes ready for the next run.

I'm thinking of changing the way this works, so that once triggered, the master workbook could create a new Excel entity and trigger off a project to run which would continue until it completes and then close. Meanwhile, if another project wanted to run while the first was still running, it could open up another excel entity and do the same. Is this possible? I guess the master workbook would need to trigger off a macro and then not wait for it to finish - is this possible?

 

[knacksc2]

to my knowledge you cannot have multiple macros running at the same time. you can have the current macro running call another macro, but the second must complete before the original will continue where it left off.