pyVBAanalysis

Static analysis for Excel VBA. It reads your macros and reports likely bugs and the errors the VBA compiler would catch, without opening Excel or running any code.

Point it at a workbook or a set of exported module files, and it returns the problems it finds, each with the exact line and a plain explanation.

What it checks

It looks for more than a hundred kinds of problem, including:

  • Type errors, such as assigning a string to a Long or passing the wrong type to a procedure.
  • Undeclared variables and calls to procedures or members that do not exist.
  • Code the VBA compiler rejects: duplicate declarations, malformed statements, or a Declare that lacks PtrSafe on 64-bit Office.
  • Likely run-time failures, such as dividing by a constant zero or a type mismatch from a bad conversion.

It only reports a problem when it can prove one, and stays quiet otherwise, so the output does not bury you in false alarms.

Install

pip install pyvbaanalysis

Python 3.10 or later. Nothing else to set up.

Use it from Python

Analyze a workbook:

from pyvbaanalysis import analyze_workbook

for module, problems in analyze_workbook("Budget.xlsm").items():
    for p in problems:
        print(module, p.severity.value, p.code, p.message)

Analyze a single module's source:

from pyvbaanalysis import analyze_module

source = "Sub Test()\n    Dim n As Long\n    n = \"oops\"\nEnd Sub\n"
for p in analyze_module(source):
    print(p.code, p.message)

Each result has a code, a message, a severity (error, warning, or information), and a span giving the character offsets in the source.

Analyze several exported files together, so references between them resolve:

from pyvbaanalysis import analyze_loose_files

analyze_loose_files(["Module1.bas", "Sheet1.cls", "UserForm1.frm"])

Use it from the command line

pyvbaanalysis Budget.xlsm
pyvbaanalysis ./exported_modules --format json
pyvbaanalysis Budget.xlsm --only Sheet1

A path can be a workbook, a folder of exported .bas / .cls / .frm files, or a single file. The command exits 1 when it finds problems and 0 when the code is clean, so it drops into a CI check.

Scope

This analyzes Excel VBA. It does not run macros and does not need Excel installed. Word and PowerPoint are not supported.

Documentation

License

MIT. See LICENSE.

Project links

Data verified by PyPI on Jul 9, 2026
Data provided by the project maintainers, verified at the time the release was uploaded to PyPI.

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Newer release available (2.0.0)

1 maintainer

PyPI data
Data sourced directly from PyPI's database.
Avatar for WilliamSmithE from gravatar.com WilliamSmithE

Credits

Author: William Smith Edward

GitHub Statistics

Data verified by PyPI on Jul 9, 2026
The GitHub source repository was provided by the project maintainers and verified by PyPI at the time of upload. Stars, forks, and open issues/PRs are derived from that repository and have not been independently verified.

License expression

MIT
View SPDX License List

Requires

Python >=3.10

Provides Extra

build dev

Tags

excel linter static-analysis vba

Classifiers

Report project as malware

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pyvbaanalysis-1.2.0.tar.gz (583.7 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

pyvbaanalysis-1.2.0-py3-none-any.whl (519.7 kB view details)

Uploaded Python 3

File details

Details for the file pyvbaanalysis-1.2.0.tar.gz.

File metadata

  • Download URL: pyvbaanalysis-1.2.0.tar.gz
  • Upload date:
  • Size: 583.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.12

File hashes

Hashes for pyvbaanalysis-1.2.0.tar.gz
Algorithm Hash digest
SHA256 cedfa295e8efe1acd5f79daa1b2e8ce2cd05417a08e9a46e7a9028c8e9e11d4e
MD5 f6b325930a6d18dc00954167c6b8fa2e
BLAKE2b-256 daf4e15824d87743b9b138b345973aa39a0ab618a1bf3193e7e77d68d0d5ecb6

See more details on using hashes here.

Provenance

The following attestation bundles were made for pyvbaanalysis-1.2.0.tar.gz:

Publisher: publish.yml on WilliamSmithEdward/pyVBAanalysis

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file pyvbaanalysis-1.2.0-py3-none-any.whl.

File metadata

  • Download URL: pyvbaanalysis-1.2.0-py3-none-any.whl
  • Upload date:
  • Size: 519.7 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.12

File hashes

Hashes for pyvbaanalysis-1.2.0-py3-none-any.whl
Algorithm Hash digest
SHA256 e7a6ab5e587005f42b9a2e5778f61a38ad6a1d89cc55ce19ebbf805d9c944f43
MD5 4a7ee9aa03417b49cdb57c2d0495c83a
BLAKE2b-256 7005825f3cf4e036a0be08ad846836c80773647ad3d5b15ae662f4405ac4970d

See more details on using hashes here.

Provenance

The following attestation bundles were made for pyvbaanalysis-1.2.0-py3-none-any.whl:

Publisher: publish.yml on WilliamSmithEdward/pyVBAanalysis

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page