VBA Generators — VS Code extension

Problem

Writing boilerplate VBA by hand — constructors, getters/setters, singleton factories — while development of a a logistics BI pipeline was slow and error-prone, and no existing VS Code tooling covered VBA’s syntax quirks.

Approach

VS Code extension was written to parse a class’s property declarations and to generate the matching constructor, accessors and singleton-factory boilerplate on demand, resulting in Marketplace publisha and open-sourced the code.

Impact

• Over 13,000 downloads on VS Code Marketplace.
• Still maintained as an open-source side project.
• Turned a personal productivity hack into a tool other VBA developers rely on.