← ClaudeAtlas

excel-addin-builderlisted

Build, package and one-click install Excel VBA add-ins (.xlam) with a custom ribbon tab. Use when the user wants an Excel add-in, an .xlam, a custom Excel ribbon, to turn macros into a reusable tool, or to distribute Excel tools to colleagues. Generates VBA modules and ribbon XML from a plain description, compiles the .xlam via Excel COM automation on Windows, and produces macro-enabled installer workbooks (x86 / x64) that install the add-in on open.
yraveragework/yraverage-officeaddins · ★ 0 · Data & Documents · score 62
Install: claude install-skill yraveragework/yraverage-officeaddins
# Excel Add-in Builder Turn a description of Excel tools into a signed-ready, distributable add-in: a **.xlam** with a **custom ribbon tab**, plus **one-click installer workbooks** the user double-clicks to have the add-in permanently loaded in Excel. ## The two runtime paths Decide this first, it changes the last two steps only. **A. Windows + Excel available** (Claude Code on the user's PC): run the build scripts yourself. The user ends up with finished files in `dist/`. **B. No Windows/Excel** (claude.ai, macOS, CI): author everything, then hand over the project folder plus `BUILD-HERE.bat`. The user double-clicks it on their PC and gets the same `dist/`. Never fake a build you could not run — say which path you took. ## Workflow ### 1. Get the spec straight (short) You need: add-in name, ribbon tab label, and the list of buttons — each with a label and what it does. Ask only for what is missing; do not interview. ### 2. Write the project Create `addins/<Name>/` : ``` addins/MyTools/ addin.spec.json <- name, version, ribbon layout, module list modules/MyTools.bas <- your macros (one module per topic) ThisWorkbook.vba <- optional Workbook_Open / BeforeClose code ``` - Copy `templates/spec.example.json` and edit it. Schema: `templates/spec.schema.json`. - **Do not hand-write ribbon XML** — the build script generates `customUI14.xml` from the `ribbon` block in the spec. - **Do not write `Ribbon.bas` or `AddinCore.bas`** — the build script injects t