Claude Code for Excel VBA

You describe what to build.
Claude Code builds, tests and fixes.

VBridge Agent is a framework that puts Claude Code inside the Excel VBA editor (VBE). You describe what to build; Claude writes the VBA, imports it, runs 45+ automated checks, reads the error log, and fixes root causes autonomously, with no copy-paste. It runs 100% locally on Windows.

VBridge lets Claude Code close the loop itself: writes, imports to the VBE, tests and fixes. You describe, it works.
Stop doing AI's job. You paste, you fix conflicts, you test, you paste the error back. This is you doing all the work while AI watches.

VBridge Agent
★★★★★5.0on Upwork
your current workflow

The loop that never ends. Sound familiar?

Every VBA developer using ChatGPT or Claude right now is stuck in the same exhausting cycle. Not because you're doing it wrong, because the tools have no way to close the loop themselves.

STEP 01

Ask AI for code

You get a function. Looks right. Copy it.

STEP 02
📋

Paste into VBA editor

Conflict with an existing variable. Wrong module. Something's already named that. Fix manually.

STEP 03
💥

Run it. Something breaks.

Compile error. Runtime error. Wrong result. Or worse, it runs fine and silently breaks something else.

STEP 04

Paste the error back to AI

Describe what happened. What you expected. What you got. AI can't see your screen. You are the debugger.

STEP 05
♻️

Get a fix. Paste it again.

The fix breaks something that was already working. Regression. Back to step 3.

STEP 06
🐛

Debug.Print. Everywhere.

Add Debug.Print to find where it goes wrong. Check Immediate Window. Clean up later.

↻   repeat until you give up or it accidentally works   ↻
THE RESULT

Half the session spent testing manually. Bugs pile up. Every fix risks breaking something else. Progress is slow. Documentation is whatever you remember to ask for. And you do all of it, AI just watches and suggests.

THE HIDDEN COST

You're a VBA developer. You know Excel inside out. Instead of using that knowledge to make decisions and build things, you spend it copy-pasting and babysitting an AI that could do 90% of this itself.

Still recognize yourself in this loop? Read the open letter. We wrote an open letter to everyone still copying and pasting at 23:40. No judgment, no lecture. Just a mirror, and one way out. Read the letter →

What is VBridge Agent?

VBridge Agent is a framework that puts Claude Code inside the Excel VBA editor (VBE). You describe what to build; Claude writes the VBA, imports it, runs 45+ automated checks, reads the error log, and fixes root causes autonomously, with no copy-paste. It runs 100% locally on Windows.

The VBA IDE was a closed door to AI. Until now.

Other developers using AI can run code, see the output, and react in a loop. VBA developers couldn't. There's no terminal. No open API. No way for Claude to see what happened inside your workbook.

So Claude gave you one function at a time, and you carried everything else yourself.

VBridge lets Claude Code drive Excel/VBA autonomously, with no intervention needed from you: it updates the VBA code right inside the editor, runs the code that lives there, captures logs and errors, and iterates. No copy-paste loop, no IDE plugin. Works on existing .xlsm/.xlsb projects, so it handles real legacy workbooks, not just new toy projects.

VBridge Agent opens that door. The bridge relies only on what is already on your machine, so the framework runs out of the box, with nothing new to install and nothing to configure.

No installs. No admin rights. No IT exception required.

Everything runs locally on your machine. No cloud execution. Your code, your workbooks and your data never leave your computer.

For the first time, Claude can import code, run it, read the results and fix what broke, without you in the middle. That was always a tooling problem, not a skill problem.

"I've tried AI but it only works for small things."

Because you've been closing the loop yourself. Without a way to test and verify, AI can only do one small step at a time before it needs you back.

"Professional devs look down on VBA."

They had better tooling. Now you can have the same: automated testing, autonomous sessions, crash-safe imports, in Excel. The gap was tooling, not skill.

"I fix one bug and two more appear."

That's regression without a safety net. When Claude runs all checks after every change, it catches what it broke before you ever see it.

"I never have time to write documentation."

Because you're too busy manually testing. When Claude handles the test loop, you get time back and the framework generates docs automatically.

Start by just asking. Nothing changes.

You don't have to let it touch anything to get value on minute one. Point VBridge at the workbook you already have open and ask about it, live. It reads the file and answers on the spot.

"What's in Dashboard!B5 right now?"

The value, the formula behind it, and its number format, straight back.

"Which modules and forms does this workbook have?"

The full component list with types, so Claude knows the lay of the land before it writes a line.

"Where does 'Invoice' appear on this sheet?"

A live search across values or formulas, answered on the spot.

It only reads. It never writes. That guarantee is the whole point: explore your file with zero risk, and move to the build-and-fix loop only when you're ready.

What your workflow looks like with VBridge Agent

The same Claude that gives you one function at a time becomes something that develops, tests, finds its own bugs, fixes them, and confirms everything passes, autonomously.

✗   YOUR CURRENT WORKFLOW
  • Ask AI for code. Copy it. Paste it. Fix conflicts manually.
  • Run it. Something breaks. You're the one who notices.
  • Copy the error. Describe it to AI. Wait for a fix.
  • The fix breaks something that worked last week.
  • Debug.Print everywhere. Clean up later. Maybe.
  • Every fix risks breaking something else.
  • No tests. No safeguards.
  • Documentation only if you remember to ask separately.
✓   WITH VBRIDGE AGENT
  • You describe what you need. Claude writes it, imports safely, tests automatically.
  • If something breaks, Claude finds it, you don't have to run anything.
  • No pasting errors. Claude reads the test log directly and fixes root causes.
  • Every fix gets a permanent guard, the same bug cannot come back.
  • Full trace logging shows exactly which line got wrong output.
  • Say "full auto" and walk away. Claude tests, fixes, guards, repeats.
  • 45+ automated checks after every change. Regression caught instantly.
  • Documentation generated as part of the session, not an afterthought.

AI that tests its own work. Every single time.

The framework builds the bridge between Claude and Excel so Claude can see what it produced, verify it works, and fix what it broke, without you in the middle.

In one sentence: Claude updates the VBA code right inside the editor, runs the code that lives there, reads the logs and errors, and iterates, with no intervention needed from you, until everything passes.

00

Your workbook is never at risk

Every session starts from a saved recovery point. A timestamped backup is taken before any change, so one click puts you back exactly where you started, no matter what happens during the session.

01

Automatic write and import

No copy-paste. Claude edits VBA source files directly and imports through a safe bridge, fully automatic, with no manual VBE work.

02

Checks run instantly

45+ checks verify output against expected results. A checklist that runs itself every time Claude touches anything. Pass/Fail in seconds, no manual testing.

03

Reads results automatically

No pasting error messages. Claude reads the check log directly, sees exactly which function returned the wrong result, and traces the input to find the real cause.

04

Fix root cause. Add permanent guard.

Not patches. Every fix targets the root cause. A permanent guard check is added so the same error pattern can't recur. No more regression surprises.

05

Autonomous loop until zero issues

Say "full auto" and Claude keeps cycling, test, fix, guard, recheck, until a full scan finds nothing.

VBridge Agent / YourProject/
> full auto - fix all failing checks
Running 45 checks...
✗ ConvertDate returned null for "29/02/2023"
✗ FormatCurrency wrong for negative values
✗ ExportRows skips last row when filtered
─────────────────────────────
Fixing ConvertDate - root cause: leap year not handled
✓ Fix applied · guard check added
Fixing FormatCurrency - root cause: ABS missing on negative
✓ Fix applied · guard check added
Fixing ExportRows - root cause: off-by-one on LastRow
✓ Fix applied · guard check added
─────────────────────────────
Re-running full scan...
✓ 48/48 checks passed · 0 failed
TRUE_SUCCESS - session complete.
You typed one line. Claude found 3 bugs, traced each to its root cause, fixed them, added 3 permanent guards, and confirmed all 48 checks pass. You did nothing except say "full auto."

Safe. Unattended. Verified.

Everything above runs without putting your file, your time, or your afternoon at risk. Here is what that means in practice.

It never corrupts your code

Every module keeps its exact type and content through the whole automated loop. A class stays a class, a form stays a form, every line and character preserved, Hebrew comments and special symbols included. This is proven by an automatic test on every build, not just promised.

Your file is never at risk

Every change is verified before it's applied, and a timestamped backup of your workbook is taken first. A change that doesn't pass is never applied, and anything that is applied stays recoverable from the backup. No "hopefully it saved correctly" step, no cleanup you have to do yourself. You can leave it running and walk away.

Works with the workbook you already have

Point VBridge at your existing workbook and start. No new API to learn, no wrapper functions to add, no refactor before you get value. Your code stays your code. Most tools ask you to rewrite first and automate second. VBridge automates the project you have today.

It tells you exactly where it broke

When something fails, you get the exact location, module, procedure and line, on the first failure. No bare error code, no guessing game, no re-running in a special debug mode. That's the difference between a fix that takes one cycle and a fix that takes six.

It fails before it wastes your time

The errors that normally kill a run in the first thirty seconds are caught up front, reported in plain language, and fixed before anything starts. A run that begins is a run that will finish.

Dialogs don't stop the run

Message boxes, prompts and file pickers are the reason unattended VBA usually isn't unattended. With VBridge you decide what every prompt should answer before the run starts, and you can run the same flow twice with opposite answers to prove both paths work. Most projects have branches nobody has tested in years. This is how you find them.

You know what will be covered before you start

Before a run begins, you see exactly which parts of your project will be exercised and which won't, and why. No ten-minute run that ends in a report full of "skipped".

Excel never gets left wedged

If something stalls, VBridge notices, stops it, and leaves your machine clean. Your own Excel session, the workbooks you have open and unsaved, is never touched. There's no task-manager cleanup ritual afterwards.

Built for the agent, not just the human

Every result comes back in a form the AI can act on directly: what happened, where in the process, and what to do next. Fewer wasted cycles, less token spend on the agent re-reading logs, and faster convergence on a working fix.

0 errors you paste manually
0 checks run after every change
faster than manual loop
0 loop iterations while you sleep

Why other options don't solve the problem for VBA developers

OPTION 1 / MCP EXCEL SERVER

Install hell. And it still can't write VBA.

MCP for Excel requires Python, pip, a running MCP server, Node or uvx depending on the version, and usually a fight with IT policy just to start. Then after all that: it can read and write cells. It cannot write new VBA, cannot run a test loop, cannot see its own output. You are still the one reporting what happened.

30 minutes of setup to end up with the same workflow you started with.

OPTION 2 / CLAUDE ADD-IN FOR EXCEL

It works on spreadsheet data. Your VBA code is invisible to it.

The Claude add-in lives in the Excel ribbon and can read cells, analyze data, write formulas. It has zero access to the VBA editor, the module list, the code behind your workbook, or the output of any macro you run. From the add-in's perspective, your VBA project does not exist.

Useful for cell work. Useless for VBA development.

Feature Comparison

CAPABILITY VBridge Agent Manual Copy-Paste Claude Add-in MCP Excel Server
🔁 Development Loop
Writes new VBA automaticallyPartial
Auto-imports to VBE✗ Manual
Runs automated checks
Reads its own error log
Autonomous bug fixing (no user)
Reads the open workbook live, read-onlyCells onlyCells only
⚙️ Infrastructure
Works with existing VBE
No server / Python / npm✗ Required
Setup in minutes~10 min30+ min
📊 Productivity
Parallel project development
Auto documentation
Full Auto development
🛡️ Safety & Unattended Runs
Verified and backed up before every change
Code type preserved on import (class stays class)
Exact failure location (module, procedure, line)✗ Error code
Runs containing prompts complete unattended
Coverage known before the run
Automatic hang recovery✗ Manual
Machine-readable results (JSON)Partial

Bottom line: Other AI tools touch the spreadsheet from the outside, reading data, writing formulas, filling cells. VBridge Agent is the only one that puts Claude inside the VBA editor itself, to write code, run it, and fix what breaks on its own.

What people say about VBridge

You're putting me out of business.

JK Jan Karel Pieterse Excel MVP · Microsoft LinkedIn

It's a genius framework.

MP Maayan Poleg Excel MVP, Israel Live session

I'm already having fun with it. This framework will save me a lot of work.

OM Orlando Mezquita CEO Live session

Watch: VBridge Agent in action

A talk by Noam Brand at the Excelists Club, using Claude Code as an AI agent that works for you in Excel: it reads your files, writes, tests and runs code end to end. The video starts directly at the VBridge segment (34:30).

How to get started? Choose your installation path.

Prerequisite: A paid Claude Pro or Max subscription.
Get a free 1-week trial of Claude Code →

Affiliate disclosure: this is a referral link. If you later purchase a subscription, I receive $10 in Claude usage credits, at no extra cost to you.

choose installation path
🔧 ClaudeCode Launchpad CLI
Zero-setup Claude Code for English & LTR languages, Windows & macOS
  • Installs Node.js, Git and Claude Code automatically
  • Bright blue terminal theme, no black screen
  • Visual folder picker, no cd commands
  • Re-running updates Claude Code to the latest version
  • Live status bar: model, context, tokens, cost & duration
  • Preserves the original Claude Code experience, no extra UI layers
Free Open Source Windows & macOS
01
Download and install ClaudeCode Launchpad CLI (one time)
Automatically installs Node.js, Git, Claude Code and the modern terminal theme
02
Copy the VBridge Agent folder to your machine
All scripts are pre-built - nothing to configure
03
Open ClaudeCode Launchpad CLI and start working
Claude Code launches automatically. First time requires Claude account login
04
Enable VBA Trust in Excel
Options → Trust Center → Trust VBA project access
FOR RTL
🌐 Kivun Terminal
Claude Code with full RTL support, Hebrew, Arabic, Persian and more
  • Installs Node.js, Git and Claude Code automatically
  • Full BiDi rendering: Hebrew, Arabic, Persian, Urdu & 8+ more
  • Hebrew text aligns right; mixed English/Hebrew positioned correctly
  • Bright blue terminal theme, no black screen
  • Live status bar: model, context, tokens, cost & duration
  • Re-running updates Claude Code to the latest version
Free Open Source Windows & Linux
01
Download and install Kivun Terminal (one time)
Automatically installs Node.js, Git, Claude Code and the RTL terminal
02
Copy the VBridge Agent folder to your machine
All scripts are pre-built - nothing to configure
03
Open Kivun Terminal and start working
Claude Code launches automatically. First time requires Claude account login
04
Enable VBA Trust in Excel
Options → Trust Center → Trust VBA project access
or
⌨️ Manual Installation
For those who prefer full control or already know Claude Code
01
Install Claude Code manually
02
Copy the VBridge Agent folder to your machine
All scripts are pre-built - nothing to configure
03
Open a command window and navigate to the folder
Click the Windows search bar, type cmd and press Enter. Type cd then paste the path
04
Start Claude Code
claude
05
Enable VBA Trust in Excel
Options → Trust Center → Trust VBA project access
Book on Upwork

Work directly with the developer who built this and uses it daily on real Excel projects

  • Full setup for your workbook, first autonomous session running same day
  • Claude connected to your existing code + automated checks running
  • Guard checks added to existing procedures, no rewrites
  • Set up for parallel project development
  • VBA development sessions with VBridge Agent running live
Book a session now →

Not a developer, or you would rather not touch VBA at all? There is a guided option where the Excel work gets done with you, on your own files: Claude Code for Excel →

Frequently Asked Questions

What is VBridge Agent?

+
VBridge Agent is a framework that puts Claude Code inside the Excel VBA editor (VBE). You describe what to build; Claude writes the VBA, imports it, runs 45+ automated checks, reads the error log, and fixes root causes autonomously, with no copy-paste. It runs 100% locally on Windows.

I already use ChatGPT and it works fine. Why would I need this?

+
ChatGPT gives you code, and you still do everything else: copy, paste into the VBE, run it, see what broke, go back and explain. VBridge Agent lets Claude Code close that loop itself. You describe what to build, it writes, imports, tests and fixes. No copy-paste, no waiting, no explaining errors.

What's the difference between VBridge and the Claude add-in for Excel?

+
The Claude add-in for Excel works inside Excel, it can help you draft code in chat, but it cannot import it to the VBE, run checks, read the error log or fix itself. VBridge Agent runs outside Excel via Claude Code CLI, a system capable of managing a complete, autonomous development cycle.

Do I have to work with the black screen (CMD)?

+
Not at all. ClaudeCode Launchpad gives you a modern, clean terminal with a bright theme, no black screen. It runs Claude Code natively on Windows and macOS without VS Code or any heavy editor.

Do I need to know DOS commands?

+
No. Only two commands are ever used:

cd [folder path], to navigate to your project folder.

claude, to start Claude Code.

After that, everything runs in plain language.

What's the difference between Claude.ai (the website) and Claude Code (the CLI)?

+
Claude.ai is a chat, you ask, it answers, but it can't touch your files. Claude Code CLI is Claude with access to your files, commands and scripts, meaning it can take real actions, not just give suggestions. VBridge uses exactly that capability.

How long does setup take?

+
If you already have a Claude Pro / Max subscription and Claude Code installed, setup takes about a minute:

1. Download the VBridge.zip file.
2. Extract the ZIP to a regular folder.
3. Start working with any file you put in that folder.

If Claude Code isn't installed yet, setup can be done as part of an Upwork session (additional fee).

Is there Hebrew / RTL support?

+
By default, Claude Code does not support Hebrew in the terminal, text comes out reversed and unreadable. I built a solution for this: Kivun, which installs Claude Code with full RTL support in one click, in about 2 minutes. Free, open source. Kivun project on GitHub

What's included in the Upwork session?

+
A 120-minute session: installation and setup on your own project, walkthrough of the recommended workflow, and a first working session on a real task, so you leave with a tangible result, not just theoretical understanding.

Want to talk before you start?

Leave your details and I'll get back to you. No spam, no mailing list, just an answer to what you asked.

  • 1
    You write what you'd like to build or automate in Excel.
  • 2
    I reply with a short feasibility take, no commitment.
  • 3
    If it's a fit, we book a first training session on Upwork.

Your details are sent directly to me via Netlify. Never shared with third parties.

Book a training session on Upwork →