vba-mcp-server

Let AI read and write your Excel VBA code directly — no manual export/import needed.

English | 中文 | 日本語

> An MCP (Model Context Protocol) server that gives Claude (and other AI assistants) the ability to directly access and modify VBA code inside Excel workbooks (.xlsm, .xlsb, .xls, .xla, .xlam).

---

If you've ever worked with Excel VBA and AI coding assistants, you know the pain:

1. Open VBA Editor, manually copy code
2. Paste into chat, ask AI for help
3. Copy AI's response back
4. Paste into VBA Editor, test, repeat...

VBA MCP Server eliminates this entirely. Claude can now read, write, create, delete, and backup VBA modules directly — just like it works with regular source code files.

---

• Direct VBA Access — Read and write VBA code in-place, no export/import cycle
• Smart Workbook Handling — Detects already-open workbooks, avoids conflicts
• Auto-Save — Workbooks are saved automatically after writes
• Full Module Management — Create, delete, read, write, list, and backup modules
• Workbook Discovery — Find all .xlsm files in a directory tree
• Backup with Manifest — Export all modules to text files with JSON metadata
• Document Module Protection — Prevents accidental deletion of Sheet/ThisWorkbook modules
• Lightweight — Single Python file (~300 lines), two dependencies

---

| Requirement | Details | |------------|---------| | OS | Windows (uses COM/Win32 API) | | Excel | Microsoft Excel (local installation) | | Python | 3.10 or later | | Trust Setting | See Excel Configuration below |

---

pip install vba-mcp-server

Then add to your MCP config:

{
  "mcpServers": {
    "vba-mcp-server": {
      "command": "vba-mcp-server",
      "args": []