VBA Plug for Project Analyzer

VBA Plug is an optional tool for Project Analyzer. It enables Project Analyzer to analyze and document Office VBA code.

• Analyze Access, Excel, Word, PowerPoint and Visio VBA code.
• Run code review and document your VBA applications.
• VBA Plug connects to Office and retrieves VBA code for Project Analyzer.

Review and document VBA systems

Project Analyzer, used together with VBA Plug, is a code review and quality control tool for Visual Basic for Applications. Detect logic flaws by automated VBA code review. Perform impact analysis before writing changes. Understand poorly documented VBA code. Reverse engineer existing VBA projects into diagrams and documentation. Save costs and keep end-users happy by delivering high-quality VBA applications with few errors. VBA Plug lets you use almost all code analyses and other features of Project Analyzer on your VBA code.

In order to analyze VBA, you need both VBA Plug and Project Analyzer. This is how it works: VBA Plug connects to Microsoft Office and retrieves your VBA code from Office documents and databases. Run code review, detect unused code, enforce coding standards, find duplicate code, surf your code as hypertext, produce code print-outs, cross-reference, create documents, jump in call trees, create diagrams, and more. VBA Plug with Project Analyzer is the most effective way to understand, improve and maintain VBA systems.

Note: This is a VBA code analysis system. It does not process any non-VBA content, such as Access database tables or Excel worksheet formulas. Certain features of Project Analyzer are limited or not available for VBA. The Online help tells the details.

Compatibility

VBA Plug v3.3 supports the following Office applications:

• Microsoft Access, Excel, PowerPoint and Word versions 2000, XP, 2003, 2007, 2010, 2013, 2016 and 2019.
• Microsoft Visio versions 2002, 2003, 2007, 2010, 2013, 2016 and 2019.
• Your Office installation can be either 32bit or 64bit.
• Non-Office VBA systems, such as AutoCAD, are incompatible with VBA Plug.

Try & buy

Project Analyzer comes with a free VBA Plug demo. Test VBA code analysis on your own files. The demo exports and analyzes a maximum of 10 VBA modules at a time. Download

For full analysis capability, order Project Analyzer v10 and VBA Plug v3.

Online help

Online help tells you more about VBA Plug.