Aivisto Oy, who develops coding tools for VB, has just posted two excellent articles on creating better and faster VB code, which apply equally to VBA and Office applications:
Optimize Loops Performance tricks for squeezing the maximum speed out of your code. Restructure loops, rebuild function calls, fine-tune conditionals, choose fast operators, pre-calculate values, and access arrays the proper way.
Release Checklist for Programs A code review checklist to go through before releasing an application to users.
No comments:
Post a Comment