multi-thread vb

[ccarruth]

Understand you really can't..you have to modify and use .NET or C or something else. Have existing VB code that works but large number of records makes it almost pointless.

Anyone have experience taking existing code and modifying to run on multi-core CPU?

C

 

[NARAYANK991]

Hi ,

Have you gone through this link ?

http://analystcave.com/excel-vba-multithreading-tool/

Or this ?

http://www.databison.com/multithreaded-vba-an-approach-to-processing-using-vbscript/

Narayan

 

[ccarruth]

The coder does not know these. Am looking for someone who has and will freelance to modify existing VB code.

 

[Hui]

Multi-threading in VBA does not exist
But depending on what your doing you can run multiple threads on the CPU external to VBA
Daniel Ferry used to have a good example of this on his blog which is down at the moment

You can see a cached version here:
http://webcache.googleusercontent.c....excelhero.com/2010/05/01/multi-threaded_vba/

 

[NARAYANK991]

Hi ,

The ultimate aim of multi-threading is to speed up execution of the code.

Depending on the code , this can probably be achieved in other ways ; multi-threading should be the last resort after you have exhausted all other options.

If you can post the code , and mention its present execution time , and how much you wish to reduce it to , we can see if anything else is possible.

Narayan

 

[ccarruth]

That would be great if possible. The code base is multi-module, pushing VB to galaxies where no one has gone before lol. Need a pair of eyeballs in code base to see what can be done.

 

[Hui]

Multi-Module means nothing, many programs use lots of modules, but they typically run sequentially

Sharing the code is the easiest way for us to see what your trying to do

Can you describe what your trying to model if you can't share the code