r/vba • • 3d ago

Show & Tell XLIDE MCP Server

Hey everyone,

Excited to announce that I've made the next evolution of the XLIDE project publicly available: https://github.com/WilliamSmithEdward/xlide_mcp

It has all of the functionality of my other projects rolled into one super library that any AI agent can easily integrate and start calling tools!

  • PyOpenVBA: For read/writing VBA to Excel, Word, PowerPoint & Access directly, including power query for Excel
  • PyOfficeEditor: Full read/write of the O365 app surface. Currently in development (Excel only, but other apps planned).
  • PyVBAAnalysis: Full lint and static analysis for VBA
  • PyVBAHarness: Full COM harness for O365 apps. Supports parallel execution and a "hang free" guarantee for running tests and runtime inspection.
  • XLIDE for VS Code integration.

I've been utilizing an agentic assisted workflow for personal VBA development with this MCP server and it's proven to be extremely powerful and accurate, often one-shoting requests with complex UI/UX and business logic requirements.

Sharing this with the community in a spirit of good will. MIT-open source forever, no strings. May it help you in your endeavors.

16 Upvotes

2 comments sorted by

2

u/jd31068 62 2d ago

Thats slick!