GoKawiilXLIDE - Excel VBA for VS Code
Edit Excel VBA code directly in VS Code. Browse modules in a sidebar tree, edit with syntax highlighting and symbol navigation (Go to Definition, Find All References, Rename Symbol), save changes back to the .xlsm file with Ctrl+S, and expose every operation to GitHub Copilot via the Language Model API.
Requirements
VS Code 1.95+
1.95+ Python 3.10+ -- the VBA read/write backend runs as a child process
-- the VBA read/write backend runs as a child process Python packages: pyOpenVBA >= 3.0.1 , openpyxl >= 3.1.0
No COM automation, no Office installation, no win32com -- works on Windows, macOS, Linux, and remote containers.
Development setup
git clone https://github.com/WilliamSmithEdward/xlide_vscode.git cd xlide_vscode # TypeScript side npm install npm run compile # type-check + esbuild bundle -> out/extension.js # Python side (optional venv) python -m venv .venv .venv \S cripts \a ctivate # or: source .venv/bin/activate pip install -r python/requirements.txt
Press F5 in VS Code to launch an Extension Development Host with the extension loaded and the watch compiler running.
... continue reading