xlide_vscode

XLIDE is a Visual Studio Code extension that lets you open, edit, and save VBA code stored inside Excel workbook files (the .xlsm format) directly from VS Code, without needing Excel or any Microsoft Office installation. VBA (Visual Basic for Applications) is the scripting language built into Excel; it is normally only editable through the Excel desktop application itself.

The extension works by running a Python process in the background that reads and writes the VBA binary format inside the workbook file. From VS Code's perspective, the VBA modules appear as a sidebar tree of files you can browse and open. Editing works like any other code file: you get syntax highlighting, the ability to jump to a function definition, find all places where a function is referenced, and rename a symbol across the whole project. Pressing Ctrl+S saves changes back into the .xlsm file directly.

Because it does not use COM automation or any Windows-specific mechanism, the extension works on Windows, macOS, and Linux, and inside remote development containers. The trade-off is that it cannot run VBA code or interact with a live Excel instance; it only reads and writes the stored code.

The extension also exposes its operations to GitHub Copilot as agent tools, meaning Copilot can list modules, read or write VBA code, and read or write cell data in the workbook. Write operations from Copilot require explicit confirmation to prevent unintended changes to production files.

In VS Code Live Share sessions, the host gets full editing capability. Guests can see and edit modules the host has already opened, but cannot browse the file tree or open new modules on their own, due to a restriction in how Live Share handles third-party extensions.