Analyze VBA
xlide_analyzeAnalyze VBA source in Office files to surface errors and warnings with exact locations, enabling fixes without requiring Office installation.
Instructions
Runs static analysis over every VBA module in an Office file and returns the problems with module, line, column, code and message. Needs no Office installation and runs nothing. Each file is measured against its own host's object model, so Word code is never judged by Excel's surface, and a Visual Basic 6 project against no host at all, because its code does not run in one. Call this after every VBA change and treat any problem at error severity as a build failure: fix it and analyze again until it is clean. Warnings are worth reading; some are style, some are the bug.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | Absolute path to the Office file. | |
| module_name | No | Report only this module's problems. The whole project is still analyzed, so cross-module references still resolve. | |
| min_severity | No | Lowest severity to report: 'error', 'warning' or 'information'. | information |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||