View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default multithreading / distributing excel code

The answer to both is no AFAIK, but why don't you post the portions of code
that are the worst offenders with some narrative and see if anyone can help
speed it up.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
ps.com...
I'm fairly sure I know the answer to this (ie no)... but.. I've
inherited a vba coded market risk model which takes a looong (hours) to
run which I'd like to speed up.

Is it possible to multithread vba?

Is it possible to distribute over more than one machine?

I suspect that these are both impossible in vba, but is there any
support available which won't need a rewrite in some other language?

Cheers

Chris