View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Using SMP on VBA over Excel


On Fri, 18 Sep 2009 19:13:13 +0100, "Steve Dalton"


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)



On Fri, 18 Sep 2009 19:13:13 +0100, "Steve Dalton"
<NOsteveSPAM(at)NOeigensysSPAM(dot)com wrote:

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.

"nGeeN" wrote in message
...
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.