VBA only uses one core. Now the CPUs are mostly multicore. I read something about converting VBA into Visual Studio to do multi-threading http://betterandfasterdecisions.com/2010/09/13/visual-basic-for-application-vs-visual-studio-part-1-performance-review/ Any one has tried it to take advantage of multicore CPUs? Is it hard? Can we still call excel functions like application.vlookup in the program?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Any one has converted VBA into VS to take advantage of multicore CPUs?

Thread starter Ceeyee
Start date Jul 31, 2011

Ceeyee

Board Regular

Jul 31, 2011

VBA only uses one core. Now the CPUs are mostly multicore.

I read something about converting VBA into Visual Studio to do multi-threading
http://betterandfasterdecisions.com...n-vs-visual-studio-part-1-performance-review/

Any one has tried it to take advantage of multicore CPUs?

Is it hard? Can we still call excel functions like application.vlookup in the program?