SonT said:
Please tell me some of the factors that may affect the performance of my vba
codes. Everytime I run my codes, the time for it to get process takes longer
on certain file. The codes are copied so they are exactly the same. Any
advice is appreciated.
Thank you.
SonT,
First of all, if the macro is recorded instead of developed manually, it
will be running using foreground processing. Foreground processing is
slower and heavily dependent on the display. Larger files will take
longer to process.
If the macro code was developed to run using background processing,
(manipulate projects objects directly rather than objects via
selection), then the processing time is more dependent on how efficient
the code is written (e.g. efficient loops, operating only on the data
necessary, etc.).
When developing macro code manually, perhaps the most important first
step is to develop an outline of what the code should do. Once the
requirements are well understood, it is much easier to develop efficient
code that meets those requirements and executes in minimum time.
John
Project MVP
