Tuesday, November 28, 2006

Towards Better and Faster VBA Code

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: