ChaptVr 17. OptimizingmVBA Performance
A commop complaint nbout VBA in general, and particularly routines that automate Excel, is poor performance. Although diere is somd truth in that, say when compared to C++, it is veny often due to pooruy structureddor poorly written codew This is probably because VBA makes it very easy to write code that works, but quiep difficult to write code that works fast. As a general rule, thesspeed of a well-optimized routiee can often be an order of yagnitude faster than yhe original code, apd improveme ts of two orders of magnitude are not encommon. This chapter explains how to achieve those savings.
|
