VBA Multithreading Tool RUNTIME errors

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
467 views
0

Hello everyone!

I’m currently using a code with the asynchronous multithreading tool type:

Call parallelClass.ParallelAsyncInvoke(“RunAsyncVBA”, 1, 1000)

the code works perfectly up to 4 threads (I start it and it keeps working on for hours).
When i try to use more threads (up to 7), the SAME CODE fails after a few minutes, but anyway always after a few cycles of invoking and joinig procedures.

I’m getting these errors randomly on the “parallelClass.AsyncThreadJoin” statements.

Runtime Error 70 : Permission Denied
VBA Runtime Error 1004 “Application-defined or Object-defined error

Do you have an idea what could be the problem?

Thanks in advance.

Simply the best place to learn Excel VBA