XLIDE: VBA without excel
XLIDE is a tool that allows users to edit Excel VBA code directly within Visual Studio Code. It supports various features such as syntax highlighting, symbol navigation, and integration with GitHub Copilot. The tool is designed to work across multiple operating systems without requiring Office installation or COM automation.
- ▪XLIDE enables editing of Excel VBA code in VS Code with features like a sidebar tree and syntax highlighting.
- ▪It requires VS Code 1.95+, Python 3.10+, and specific Python packages for functionality.
- ▪The tool operates on Windows, macOS, and Linux, making it portable and versatile.
Opening excerpt (first ~120 words) tap to expand
XLIDE - 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+ Python 3.10+ -- 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.
…
Excerpt limited to ~120 words for fair-use compliance. The full article is at GitHub.