Curious to know is there a way to run multiple macros at once...literally at the same time.
For example, let's say I had a macro "A" which works well but takes three hours to complete...
I'm wondering if I open three sessions of MS Excel and run macro "A1", "A2", and "A3" if I can cut down the time to one hour...since it was stacked/parallel processed.
The only thing I could come up with (which may no work) is to create multiple timed events for the macros to be triggered independently at the same time (or staggered by a bit of time)...
Any thoughts would be helpful...
For example, let's say I had a macro "A" which works well but takes three hours to complete...
I'm wondering if I open three sessions of MS Excel and run macro "A1", "A2", and "A3" if I can cut down the time to one hour...since it was stacked/parallel processed.
The only thing I could come up with (which may no work) is to create multiple timed events for the macros to be triggered independently at the same time (or staggered by a bit of time)...
Any thoughts would be helpful...
