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?