XLIDE: VBA for VS Code

Install XLIDE from the Visual Studio Marketplace

XLIDE gives Microsoft Office VBA projects a modern VS Code workspace. Read and write directly to VBA files directly without COM.

Add macro-enabled Office files to your VS Code project and XLIDE detects them automatically: Excel workbooks, templates, and add-ins (.xlsm, .xlsb, .xlam, .xltm, .xls, .xlt, .xla), Word documents and templates (.docm, .dotm, .doc, .dot), PowerPoint presentations and add-ins (.pptm, .potm, .ppsm, .ppam, .ppt, .ppa), and Access databases (.accdb, .mdb, .mda, read-only). Navigate each file's VBA project in the XLIDE tree, open modules directly from the file, edit with host-aware IntelliSense (Excel modules complete against Excel's object model, Word modules against Word's, and so on), and save changes back with normal VS Code save behavior. When you want a file-based workflow, use the full local disk push/pull workflow for the selected file: preview detailed side-by-side diffs, export modules to .bas and .cls files, commit them to your favorite version control platform, and import reviewed files back.

For new programmers, XLIDE makes the VBA language easier to approach. It shows useful completion lists, explains symbols, highlights likely mistakes, and keeps each file's project structure visible while you learn how Office automation fits together.

For experienced VBA developers, XLIDE brings serious engineering workflows to existing files: project-wide symbol navigation, rename and reference tools, full static analysis, live diagnostics, file-level analysis reports, module-qualified IntelliSense, import/export diff previews, source-control friendly .bas/.cls sync, explicit per-file settings, performance diagnostics, and VBA unit tests that execute through Excel, Word, or PowerPoint when you need runtime confidence.

For everyone, XLIDE opens a new agentic AI surface for Office VBA. Compatible AI assistants can inspect the real file, read and write VBA modules, analyze code, run tests, inspect worksheet data, and sync modules with files through explicit XLIDE tools. That means AI help can work with the document itself, not just copied snippets or stale exports, making Office automation more reviewable, testable, and collaborative.

Why Use XLIDE

1. Make VBA easier to learn and maintain VBA is powerful, but its rules, project structure, and the host object models can feel hidden. XLIDE makes them visible with project navigation, IntelliSense, hover explanations, signature help, semantic coloring, and immediate feedback while you type.

2. Catch VBA mistakes earlier XLIDE shows live red and yellow squiggles for many high-confidence VBA problems: missing block closers, duplicate names, undeclared variables, invalid parameter/property shapes, array misuse, bad Set usage, common #If pitfalls, and more.

3. Get IntelliSense that understands your file and its host Completion and tooltips know about your modules, classes, functions, constants, enums, user-defined types, XML documentation comments, and the object model of the host the file belongs to - Excel members in a workbook, Word members in a document, PowerPoint and Access members in theirs.

4. Edit workbook VBA in a real code editor Work with workbook modules in VS Code using normal editor habits: tabs, search, save, rename, Go to Definition, Find All References, hover, signature help, formatting-friendly indentation, and semantic coloring.

5. Keep workbook code reviewable Export modules to .bas and .cls files, preview exactly what will change, and use source control workflows without guessing what is inside a binary workbook.

6. Import and export safely XLIDE previews create, update, overwrite, and delete actions before applying them. Workbook-specific settings live beside the workbook so each project can keep its own sync rules.

7. Analyze the whole file Run file-wide analysis over any container - workbook, document, presentation, or database - and review findings in a dedicated report instead of hunting through modules one by one.

8. Run macros and VBA tests when Office is available On Windows with Microsoft Office installed, XLIDE runs macros and @xlide-test unit tests through explicit automation of the file's own application - Excel, Word, or PowerPoint.

9. Give AI assistants real file context XLIDE exposes tools for file discovery, VBA reads/writes, analysis, tests, sheet/cell access, formulas, and module sync so agents can work from the actual Office file instead of stale exported copies.

Who It Is For

XLIDE is useful if you:

• Are learning VBA for a class, internship, first automation project, or career change.
• Use Excel heavily and want to start programming without losing sight of the workbook.
• Are a student, analyst, accountant, engineer, researcher, or operations user turning repeated spreadsheet work into reusable automation.
• Own business-critical Excel workbooks with VBA.
• Maintain shared macros for finance, operations, reporting, engineering, or internal tools.
• Want better visibility into old VBA projects before changing them.
• Need to review workbook code with teammates.
• Prefer VS Code editing, search, navigation, and source control.
• Want AI help that can inspect the workbook directly.

Excel remains where the workbook runs. XLIDE adds a better workspace around the VBA project.

Get Started

1. Install the extension: XLIDE on the Visual Studio Marketplace

2. Open a folder in VS Code that contains an .xlsm, .xlsb, or .xlam workbook.

3. Expand your workbook in the XLIDE view, open a module, and start editing. Press Ctrl+S to save code back to the workbook.

There is nothing else to install: XLIDE reads and writes workbooks itself, with no external runtime and no setup step.

Start here for a guided first-hour walkthrough: Getting started with XLIDE

Everyday Workflow

Edit VBA modules

Open a workbook in the XLIDE tree, choose a module, edit it in VS Code, and save. XLIDE writes the module back to the workbook.

Fix red squiggles

Live diagnostics appear as you type. For a bigger pass, run XLIDE: Analyze Workbook from the workbook menu and review the analysis report.

Guide: Analysis and ignores

Sync code with files

Use Export Modules to Folder to create or update .bas and .cls files. Use Import Modules from Folder to bring reviewed files back into the selected workbook. XLIDE shows a workbook-scoped preview before applying changes.

Guide: Import and export

Run tests

Mark VBA procedures as workbook tests, then run them from XLIDE. Test execution requires Microsoft Excel on Windows.

Guide: Testing VBA workbooks

Use AI assistants safely

XLIDE gives compatible VS Code AI agents tools to inspect and edit workbook VBA, run analysis, export modules, and read worksheet data with explicit workbook context.

Guide: Automation and CI

What XLIDE Adds To VS Code

• Workbook and module tree for .xlsm, .xlsb, and .xlam files.
• Writable VBA editors backed by the workbook.
• VBA syntax highlighting and semantic coloring.
• IntelliSense for workbook symbols, VBA language features, and Excel host objects.
• Hover, signature help, Go to Definition, Find All References, and Rename Symbol.
• Smart Enter and block snippets for common VBA structures.
• Live diagnostics and workbook-wide analysis.
• Workbook-specific analysis tracking and rule controls.
• Previewable module import/export.
• Macro and workbook-test execution on Windows with Excel.
• Support bundle and diagnostics commands for troubleshooting.
• Optional performance snapshot command for debugging slow workflows.

Requirements

Required for normal browsing, editing, analysis, import, and export:

• Visual Studio Code 1.95 or newer.

That is the whole list. XLIDE parses and rewrites the workbook container (OLE compound file, VBA project, and OOXML package) natively in the extension, so there is no runtime, interpreter, or library to install.

Required only for running VBA code from XLIDE:

• Windows.
• Microsoft Excel.
• Workbook macro settings that allow the code to run.

Reading, editing, analyzing, importing, and exporting workbook VBA do not require Excel automation.

Setup and recovery guide: Safety, trust, and support

User Guides

Common Commands

Open the Command Palette and type XLIDE to find these commands:

Notes And Limits

• XLIDE reads and writes VBA modules through the workbook file. Keep normal backups for important workbooks, especially before large sync operations.
• Running macros or tests uses Excel automation and is Windows-only.
• UserForm designer files are not edited directly. XLIDE can work with the VBA code-behind where supported.
• Exported .bas and .cls files are useful for review and source control, but the workbook remains the source of truth unless you explicitly import files back into it.

For Developers And Contributors

Repository: https://github.com/WilliamSmithEdward/xlide_vscode

git clone https://github.com/WilliamSmithEdward/xlide_vscode.git
cd xlide_vscode

npm install
npm run compile

Press F5 in VS Code to launch an Extension Development Host.

Useful development commands:

Architecture reference: XLIDE architecture

Support Open Source

XLIDE is open-source software. If it saves you time or helps your team keep VBA workbooks maintainable, support helps keep the project moving.

• GitHub Sponsors
• PayPal
• Cash App