Multithreading tool

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Solved2.61K views

Hi, thank you for the tool. I am trying to call a macro with a lot of parameters already but it is a simple for loop. Is there any way to use your tool with all my parameters?

Changed status to publish

This question is outdated but posting answer. There are many ways to do this:

1. By default the Parallel methods support up to 6 parameters. You can modify the class to support more
2. The Parallel class actually replicates the running Excel file and runs the loops on copies of itself this means you can reference any existing worksheets in your workbook i.e. post any number of parameters in an existing worsheet
3. Last option – most elaborate if you want to pass classes, arrays or other objects to the child processes is to save these to binary files and simply reopen them from the child process. Read my post here.

Selected answer as best

Simply the best place to learn Excel VBA