will 2007 multithreading capability help the vba<-->worksheet tran

[larry godfrey]

A vba speed bottleneck can be the transfer of data between the workbook and
the macro.

Will 2007 address this issue, perhaps with multithreading?

Regards
Larry

[John.Greenan]

No. Not as far as I have seen. The multithreading part is not really
applicable to getting data from the excel worksheet into code.


--
www.alignment-systems.com


"larry godfrey" wrote:

> A vba speed bottleneck can be the transfer of data between the workbook and
> the macro.
>
> Will 2007 address this issue, perhaps with multithreading?
>
> Regards
> Larry

[Nick Hodge]

Larry

The multi-threading is limited to the calculation engine, so I think not

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"larry godfrey" <larrygodfrey@discussions.microsoft.com> wrote in message
news:590A2C08-776E-4A33-81BA-DD95300984D1@microsoft.com...
>A vba speed bottleneck can be the transfer of data between the workbook and
> the macro.
>
> Will 2007 address this issue, perhaps with multithreading?
>
> Regards
> Larry