$ loading_
Lets AI directly read and write VBA code in Excel workbooks.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "VBA MCP Server" yet — see the docs or source repo.
Read all VBA modules in this Excel workbook and list their code by module name so I can review the existing macro logic.
A list of VBA modules in the workbook with their corresponding code content.
Update the VBA code in the workbook module named Module1 with new data-cleaning logic and write it back directly to the Excel file.
The VBA code in the specified module is modified and written back to the workbook.
Find and modify a VBA procedure directly in the current Excel workbook without manually exporting and re-importing modules.
The target VBA procedure is read and updated directly in place.
Developers or advanced office users can have AI read VBA code directly from a workbook to review and adjust macro logic. This reduces the repetitive steps of manually exporting, editing, and re-importing modules.
When VBA code inside an Excel file needs to be updated directly, this MCP tool can read and write it via COM. It fits quick iteration around existing workbooks.
It enables AI assistants to directly read and write VBA code in Excel workbooks via COM. Its main value is removing the manual export/import cycle for VBA modules.
It is known to rely on COM to interact with Excel workbooks. For exact installation, runtime, or permission requirements, see the source repository.
The difference is that it lets AI read and write VBA code directly inside the workbook, without manual export and re-import steps. That makes it better suited for automated edits and rapid iteration.
Add, edit, and run VBA modules in Windows Excel for automation.
Lets AI read, write, format Excel files, and create charts via MCP.
Automate Excel editing, formatting, charts, and sheet management with natural language.
Automate Excel tasks, formulas, and workbook operations through AI-powered tooling.
Manipulate, update, and organize Excel files through AI-driven commands.
Use AI to read, edit, format, and analyze Excel files efficiently.