Guest_imported
New member
- Jan 1, 1970
- 0
Hi all,
I am just wondering if any of you might be able to point me to some reference on how threading works in VBA. Specifically Excel (but I suspect all VBA functions similarly).
I am currently having a problem with my Excel thread that I create using an API call to CreateThread. I am able to spawn a thread for the specific Sub I want to run threaded... BUT within the Sub I make calls to other functions and subs located in different modules and sheets. When I make a call from this sub to something like MySheet.MySheetSub, I get an error "Runtime error '7', Out of memory". Before I had this application threaded I could run my (now threaded) sub and make calls to different public subs, functions and variables within other sheets without a problem. But now that it is threaded I get this error.
If anyone has an idea of why this is happening plz let me know. Or some reference on threading in VBA would help too. MSDN has jack on threading for VBA.
Thanks in advance,
cLocKwOrk
I am just wondering if any of you might be able to point me to some reference on how threading works in VBA. Specifically Excel (but I suspect all VBA functions similarly).
I am currently having a problem with my Excel thread that I create using an API call to CreateThread. I am able to spawn a thread for the specific Sub I want to run threaded... BUT within the Sub I make calls to other functions and subs located in different modules and sheets. When I make a call from this sub to something like MySheet.MySheetSub, I get an error "Runtime error '7', Out of memory". Before I had this application threaded I could run my (now threaded) sub and make calls to different public subs, functions and variables within other sheets without a problem. But now that it is threaded I get this error.
If anyone has an idea of why this is happening plz let me know. Or some reference on threading in VBA would help too. MSDN has jack on threading for VBA.
Thanks in advance,
cLocKwOrk
