Using SMP on VBA over Excel

  • Thread starter Thread starter nGeeN
  • Start date Start date
N

nGeeN

Hi. I work with a lot of numbers, not hard math operations, but a very large
amount of numbers. Is there any way to use both cores of my Core 2 Duo
processor in order to speed my programs up?

Thanks a lot 4 your help.
 
Get a faster machine with more memory, or split your data sets so that multiple machines can be
used. There is nothing that you can do from VBA.

HTH,
Bernie
MS Excel MVP
 
I'm not sure if I've understood your problem necessarily, but Excel 2007 is
multi-threaded and, depending on how it is configured and how the
dependencies between your spreadsheet cells are organised, will divide
built-in function recalculation between the number of threads configured.
With a dual-processor machine, 2 threads will be given roughly equal
processor time. There is no straighforward way of doing this with earlier
versions unless you can split your processing between 2 workbooks each in
its own running instance of Excel.
 
Now there's a name I haven't heard in a while. I just got back from 10
weeks in New York.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Back
Top