ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   will 2007 multithreading capability help the vba<--worksheet tran (https://www.excelbanter.com/excel-programming/365806-will-2007-multithreading-capability-help-vba-worksheet-tran.html)

larry godfrey

will 2007 multithreading capability help the vba<--worksheet tran
 
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

will 2007 multithreading capability help the vba<--worksheet tran
 
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

will 2007 multithreading capability help the vba<--worksheet tran
 
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
HIS


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





All times are GMT +1. The time now is 10:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com