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.