vba-mcp-server MCP Server
xiongchenghou/vba-mcp-server
MCP server for direct Excel VBA code read/write. Let AI assistants (Claude, etc.) access and modify VBA modules without manual export/import.
claude mcp add agentrank -- npx -y agentrank-mcp-server Overview
xiongchenghou/vba-mcp-server is a Python MCP server licensed under MIT. MCP server for direct Excel VBA code read/write. Let AI assistants (Claude, etc.) access and modify VBA modules without manual export/import. Topics: ai-tools, automation, claude, claude-code, excel, excel-vba, mcp, mcp-server, model-context-protocol, python, vba, win32com.
Ranked #61 out of 129 indexed tools.
Actively maintained with commits in the last week.
Ecosystem
Score Breakdown
1 stars → early stage
Last commit today → actively maintained
No issues filed → no history to score
1 contributor → solo project
No dependents → no downstream usage
Weights: Freshness 25% · Issue Health 25% · Dependents 25% · Stars 15% · Contributors 10% · How we score →
How to Improve
Matched Queries
From the README
# VBA MCP Server **Let AI read and write your Excel VBA code directly — no manual export/import needed.** English | [中文](README.zh-CN.md) | [日本語](README.ja.md) > An [MCP (Model Context Protocol)](https://modelcontextprotocol.io/) 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`). --- ## Why This Exists 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. --- ## Features - **Direct VBA Access** — Read and write VBA code in-place, no export/import cycle - **Smart Workbook Handling** — Detects already-open workbooks, avoRead full README on GitHub →
Get the weekly AgentRank digest
Top movers, new tools, ecosystem insights — straight to your inbox.