WilliamSmithEdward

WilliamSmithEdward / xlide_vscode

Public

Excel VBA integration for VS Code - Tree View / Full Direct VBA Read+Write / LiveShare Compatible / Direct Agentic AI Integrations

marketplace.visualstudio.comitems?itemName=WilliamSmithE.xlide agentic-ai agentic-coding ai-tools excel vba
33
0
89% credibility
Found May 28, 2026 at 33 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
TypeScript
AI Summary

XLIDE is a VS Code extension that lets you edit Excel VBA macros directly in VS Code. Instead of using Excel's built-in VBA editor, you get a modern code editing experience with syntax highlighting, code navigation (go to definition, find references, rename symbols), and the ability to save changes back to your Excel files. The extension reads Excel files directly without needing Excel installed, and can export your VBA modules to separate files for version control. It also integrates with GitHub Copilot so an AI assistant can read and modify your Excel macros.

How It Works

1
💡 You want to edit Excel macros in a real code editor

You've been writing VBA macros in Excel's clunky editor and dream of using VS Code instead.

2
📦 You install XLIDE from the VS Code marketplace

One click to install, and the extension automatically sets up everything it needs to read your Excel files.

3
🔍 Your Excel workbooks appear in a sidebar

XLIDE shows all your .xlsm files in a tree view. You click to expand and see every VBA module inside.

4
✏️ You click a module and start editing

The VBA code opens in your editor with proper syntax highlighting. You make changes just like any other code.

5
You have options for saving your work
💾
Save directly to Excel

Press Ctrl+S and your changes are written straight back into the .xlsm file, ready to use.

📁
Export to separate files

Export all modules to a folder as individual .bas and .cls files, perfect for tracking changes in Git.

6
🔍 You navigate your code like a pro

Jump to any definition, find all places where a variable is used, or rename a procedure across your entire workbook.

🎉 Your macros are now in a real development environment

You have syntax highlighting, code navigation, version control, and can even ask Copilot to help write your VBA code.

Sign up to see the full architecture

5 more

Sign Up Free

Star Growth

See how this repo grew from 33 to 33 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is xlide_vscode?

This is a VS Code extension that lets you edit Excel VBA code directly in VS Code. Instead of wrestling with the clunky VBA editor inside Excel, you get a sidebar tree view of all your modules, proper syntax highlighting, and navigation features like Go to Definition and Rename Symbol. Changes save back to the .xlsm file when you hit Ctrl+S. The extension runs a Python backend that reads and writes the VBA binary format directly—no COM automation or Excel installation required. It also exposes all operations to GitHub Copilot through the Language Model API, so AI agents can read or modify your macros.

Why is it gaining traction?

The killer feature is working without Excel installed. Most VBA tooling requires you to have Excel running or rely on Windows COM automation. XLIDE reads the OVBA binary format directly through pyOpenVBA, which means it works on any platform. The Copilot integration is the real hook—your AI assistant can actually understand and modify your macros, not just chat about them. The architecture is solid too: a long-lived Python process keeps things fast, and the virtual file system approach means Ctrl+S just works without any custom save handling.

Who should use this?

Excel developers tired of the built-in VBA editor will find this immediately useful. Data engineers who automate Excel workflows can stay in their preferred IDE. Teams already using GitHub Copilot can now have AI agents that actually modify VBA code. Anyone maintaining legacy Excel macros will appreciate the cross-module navigation and refactoring support.

Verdict

This is a genuinely useful extension for a niche that's been underserved. The architecture is well thought out—no COM, cross-platform, Copilot-ready—and the code quality shows care. At 33 stars it's early but functional. The credibility score of 0.8999999761581421% reflects its newness, but if you work with VBA regularly, this is worth installing to see if it fits your workflow.

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.