Making Development Better with Static Analysis

Question

I find, when I'm reviewing VBA code, that most of the bugs are easily classified errors, such as typos, not setting things to Nothing, not closing DB connections, etc.

I know that using "Option Explicit" can solve some of these, but I'd rather use something more powerful.

Are there any static analysis tools for VBA?

Answer 1

You can perhaps start by using MZ-Tools. While it does not have much in the realm of static analysis features, it is free and does provide some help in managing and editing your code base.

One feature it has that does perform a form of static analysis is:

• Review Source Code- An extremely limited version of code analysis. It tells you if a variable, constant, or procedure is not being used. Good to help clean up your code and get rid of cruft.

Answer 2

Project Analyzer: VBA Plug v3
MZ Tools
VBA Code Profiler *

• no idea whether this is supported still, or what the quality of the product is like.