View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Can Excel take advantage of multiple processors and hypherthreadin

To the best of my knowledge, no it can not. (particularly for a macro)

--
Regards,
Tom Ogilvy

"IanJ GSK" <IanJ wrote in message
...
Data is extracted from a 50M text file and presented in Excel.
Currently takes 20 minutes to run.
Macro does around 40 excel ops per data item, appox 400K data items.

We don't have the resource to fix macro so looking for a 'quick' win and

was
wondering if it was worth investing in more hardware.

Can Excel take advantage of multiple processors and hypherthreading?