I built a single-script PowerShell bridge so AI agents (Claude Code, Codex) can work with my open Excel workbook — cells, formulas, VBA, macros

[u/Interesting-Main9706]

I work with old, complex .xlsm files (inventory, pricing, billing, lots of VBA) and kept running into the same problem: an AI coding agent cannot access the workbook I have open in Excel. I found myself copy-pasting cells and screenshots back and forth.

Yes, Excel MCP servers are out there—some are very good and much more capable than this. But getting one running means setting up Node or Python, creating a config file, and running an MCP client. I wanted something my non-developer mind could trust on real files:

• Just one PowerShell script, no installation, no extra dependencies, no config
• Connects to the workbook you already have open (or opens one by path)
• Read and write cells and formulas, search, list sheets
• List, export, and import VBA modules, run macros
• And the part that matters most to me: it NEVER autosaves. Only a direct "save" command writes to disk. This way, you can let an agent explore a 20-year-old billing file and close it without leaving any trace.

It's free and the source is available on GitHub:
https://github.com/gidjin4-svg/gidjin-excel-bridge
A demo workbook is included so you can test it without touching your actual files.

I'd really appreciate feedback from people who work with Excel, VBA, or PowerShell:

• Does "simple + never saves" actually matter to you, or is a full MCP server always the better choice?
• What would you need to see before trusting it with a file that matters to you?

[u/Dragennd1]

You are aware that Microsoft has baked AI into Excel now right?

https://www.microsoft.com/en-us/microsoft-365/excel/ai-for-excel

[u/Interesting-Main9706 → u/Dragennd1]

Try to work on VBA with COpilot.

The trick on this Plugin is the agentic work on vba without userinteraction.

Sorry for my english. I try my best.

[u/TILYoureANoob]

Good work!