ag-vba-auditor

What problem does it solve?

Manually reviewing Excel VBA code for hidden security risks, performance bottlenecks, error handling gaps, and coding standard violations is time-consuming and error-prone, especially for large or complex workbooks shared across teams.

Core Features & Use Cases

• Comprehensive Rule-Based Audits: Detects critical security risks like Shell execution, SendKeys, and registry access, plus performance issues such as cell-by-cell loops and unnecessary Select/Activate calls.
• Structured Reporting: Outputs findings in standardized markdown and JSON formats with clear severity levels, locations, and remediation recommendations.
• Use Case: A finance team can audit a shared quarterly reporting workbook to confirm no malicious macros are present, ensure it runs efficiently on user machines, and complies with internal coding standards.

Quick Start

Use the ag-vba-auditor skill to review the VBA code in the attached Excel workbook 'Q3_Report.xlsm' for security and performance issues.