HOW TO IMPROVE PERFORMANCE FOR VB

[dhomer]

I created vs for excel 11.81 on an NT box then loaded it onto a new version
of excel on Vista. The execution performance is an order of magnatude slower
in Vista and the new version of excel 12.06.
The code is simple formating and reading from one sheet and writing to cells
in another sheet in the same workbook.
Both systems are dual core with the same memory. Vist has faster processors.
Any configurations or tricks on using the new excel on vista?

 

[Charles Williams]

Excel 12 is quite a lot slower than previous versions with VB, but maybe the
SP1 update due out next week will improve things.

Standard speedup tricks - you need to
- read and write many cells at once using Variant=Range and Range=variant
- uninstall Google Desktop Office COM addin.
- switch off screenupdating and automatic calculation

To see the performance implications/example download the variantbenchmark
from
http://www.decisionModels.com/downloads.htm

Charles
_________________________________________
FastExcel 2.3
Name Manager 4.0
http://www.DecisionModels.com