Multithreading VBA

[bradyboyy88]

I was wondering if anyone had any subroutines or subroutine examples in "multithreading VBA" I know VBA is by nature single threaded but I know there are ways of trying to emulate this type of processing and was curious what type of solutions existed on Mrexcel. My other question is have you noticed much of a performance gain by utilizing these techniques?

 

[RedBeard]

This might be of interest: http://analystcave.com/excel-multithreading-vba-vs-vbscript-vs-c-net/

 

[bradyboyy88]

Thanks for that. I have read that as well as numerious stackexchange articles as well. I was curious about another idea which you might know the answer to. Imagine 2 workbooks in the same instance, can you run 2 macros simultaniously or does this require 2 seperate instances? Can 2 seperate instances of excel share variables and if not how would you transfer values between seperate instances?

 

[RedBeard]

That's... a really good question. I don't know.