VBDepend :: VB6/VBA Static Analysis and Code Quality tool

Understand, Measure and Improve your VB6/VBA
code quality with VBDepend.

(incl. Excel, Access and Word files)
Francesco Balena - Cofounder of Code Architects.

"VBDepend is phenomenal and very useful! As a matter of fact, we recommend it to all our customers, especially for large migration projects."

We will never sell or share your email address to any 3rd party. Promise.

VBDepend is able to tell the developer that over the past hour, the code just written has introduced debt that would cost for example about 30 minutes should it have to be repaid later. Knowing this, the developer can fix the code before even committing it to the source control.

With VBDepend code rules are LINQ queries that can be created and customized in a matter of seconds. These queries contain formulas to compute accurate technical debt estimations.

The default rule-set offers over a hundred code rules that detect a wide range of code smells including entangled code, dead-code, API breaking changes and bad OOP usage.

As a static analyzer, VBDepend will likely find hundreds or even thousands of issues affecting a real-world code base. Stopping work to attempt to fix all issues for weeks would be quite unproductive.

This is why VBDepend offers a baseline. The tool estimates the Technical Debt progress since the baseline.

Recent code smells that should be fixed before committing any code to source control are highlighted in VisualVBDepend. They can then be fixed even before reaching the source server.

As a consequence the Code Quality remains under control with no major upfront investment.

A Quality Gate is a code quality criterion that must be enforced before releasing and eventually, before committing to source control.

A dozen of default Quality Gates are continuously checking measures such as overall Code Coverage by tests or extra Technical Debt since baseline.

With VBDepend, a Quality Gate is a LINQ query easy to customize and create. This unique approach offers the required level of flexibility to enforce what really matters for your organization.

Because we know developer time is invaluable, VBDepend is fast, very fast.

The technical debt can be re-estimated within just a few seconds, even for hundreds of rules passed on a very large code base and, as we are aware of its importance, without any noticeable IDE slow down.

Fixing issues is much easier as the developer is immediately informed with no delay of new issues just created, while the context is still fresh in her mind and while the code is not checked-in yet to the source control server.

Because a picture is worth a thousand words, VBDepend proposes several unique ways to visualize your code. This includes:

Code maintainability improves. This positively impacts the productivity of development teams.

Over time, developers get educated about rules to follow and their skills improve.

Architects can anticipate the impact of code changes. The right decisions are taken early.

Since quality is checked automatically and continuously with a strong focus on recent changes, the team builds better code.

Executives gain control over costs and risks thanks to light being shed on development facts and trends that matter most.

They use VBDepend

Latest ScreenShots