Using SMP on VBA over Excel
 

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.

Using SMP on VBA over Excel
 

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


"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.

Using SMP on VBA over Excel
 

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.

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.