ag-vba-auditor

Auditing Excel VBA macros for security vulnerabilities involves scanning the code for critical risks like Shell execution, SendKeys, and registry access. This process detects hidden threats and outputs structured findings with severity levels and remediation recommendations.

Optimizing Excel macro performance requires identifying inefficiencies like cell-by-cell loops and unnecessary Select or Activate calls. A code audit pinpoints these bottlenecks, providing actionable recommendations to ensure the automation runs efficiently on user machines.

Yes, you can review exported VBA module files offline. The auditor analyzes standalone .bas, .cls, and .frm module files to find coding standard violations and error handling gaps without needing a local Excel installation.

Yes, you need the pywin32 library on a Windows system to perform COM-based VBA extraction directly from Excel workbooks. This setup allows the auditor to automatically read and analyze macro code embedded in .xlsm files.

A VBA code audit checks for error handling gaps by scanning the macro logic for missing or incomplete error management structures. It identifies where runtime errors could crash the workbook and outputs structured reports detailing the exact locations and fixes needed.

Common coding standard violations in shared corporate Excel workbooks include unsafe execution calls and inefficient object references. An audit reviews the VBA code against defined standards to ensure compliance and outputs structured findings in markdown and JSON formats.