excel-vba 0.5.0

Edit, export and import Excel VBA code from the command line. Thin entry-point wrapper for vba-edit.

excel-vba belongs to vba-edit CLI Tools

Edit VBA code in VS Code, PyCharm, Wing IDE, or any editor you love. Real-time sync with MS EXCEL. Git-friendly. No more VBA editor pain.

This is a thin entry-point package for vba-edit. Installing excel-vba gives you the excel-vba command and automatically installs the vba-edit core package.

Quick Start

RECOMMENDED: Via uvx

uvx excel-vba edit -f myfile.xlsm --vba-directory .\src\VBA

Note: The uvx command invokes a tool without installing it — same as: uv tool run excel-vba

30-Second Demo

# Start editing (uses active Excel workbook)
uvx excel-vba edit

# That's it! Edit the .bas/.cls files in your editor. Save = Sync.

How It Works

                        <--- vba-edit --->

   MS EXCEL                  COMMANDS              Your favourite
                                v                       Editor

+------------------+                            +------------------+
|                  |                            |                  |
|   VBA Project    |   <---   EDIT*   (once ->) |  (e.g. VS CODE)  | 
|                  |                            |                  |     latest
|  (Office VBA-    |          EXPORT      --->  |   .bas           |  <- AI coding-  
|    Editor)       |                            |   .cls           |     assistants
|                  |   <---   IMPORT            |   .frm           |   
|                  |                            |  (.frx binary)   | 
|                  |                            |                  |     optional
|                  |                            |  [.toml]         |  <- support for 
|                  |                            |                  |     references
+------------------+                            +------------------+
                                                         v
                                                +------------------+
                                                |                  |
 * watches & syncs                              |    (e.g. Git)    |
   back to Office                               |  version control |
   VBA-Editor live                              |                  |
   on save [CTRL+S]                             |                  |
                                                +------------------+

Install

pip install excel-vba

Note: Installing excel-vba also installs the vba-edit core package, which provides entry points for all supported Office apps (excel-vba, word-vba, powerpoint-vba, access-vba).

Usage

All commands below work with both excel-vba <command> (installed) and uvx excel-vba <command> (no install required).

Command	What it does
excel-vba edit	Start live editing
excel-vba export	One-time export
excel-vba import	One-time import
excel-vba export --open-folder --keep-open	Export and open folder in explorer, keep document open for inspection
excel-vba export --force-overwrite	Export without confirmation prompts
excel-vba references list	List VBA library references
excel-vba check	Verify status of Trust access to the VBA project object model

💡 Complete Option Matrix: available here

For full documentation see github.com/markuskiller/vba-edit.