FormulaSurge

Services · VBA Maintenance

VBA Macro Maintenance: Keep Your Old Macros Working

Fixed, documented and made safer by a person who tests them on your data - tested on your real files.

  • vba
  • macro
  • maintenance
  • 64-bit
  • blocked macros
  • copilot

Start here · Scoping Sprint

Know the exact price in 2 working days. $99, credited in full to your build.

Builds from $75, fixed in writing · Working draft in 5 days or your first payment back · Mutual NDA first if you want one

See a sample Sprint report →Who you'll work with: two partners, 10+ years on finance workbooks →

10+ years in ExcelNamed senior ownerFixed price, in writingDraft in 5 days or refundMutual NDA on request30-day warranty

A macro someone wrote years ago still runs a key report, and nobody on the team knows how it works. Then a Microsoft 365 update, a move to 64-bit Office or a new security setting stops it, and the month-end pack is late.

AI assistants can suggest VBA code, but someone still has to read the existing macro, run it on your real files and confirm the fix works. That is the work we do, at a fixed price agreed before we start.

What we do

What VBA maintenance covers.

Fix broken macros

Errors after updates, 64-bit Declare statements, missing references, changed file paths and macros blocked by Mark of the Web.

Document what it does

A plain-English guide to every macro: what it reads, what it changes and what to do when it stops.

Make it safer

Error handling, input checks and a log, so a bad file stops the macro with a clear message instead of corrupting a report.

Move steps to Power Query

Where a macro only imports and cleans data, we can replace it with a Power Query refresh that needs no macro security at all.

Prices

What each price band includes.

The exact price is fixed in writing before any work starts. Bigger jobs start with the Scoping Sprint, credited in full.

Quick fix

$75 – $180

One broken macro: an update error, a 64-bit fix or a blocked file.

  • Delivery: 1–5 working days
  • 1 review round
  • 30-day warranty

Standard

$180 – $500

Several related macros fixed, documented and given error handling.

  • Delivery: 10–15 working days
  • 2 review rounds
  • 30-day warranty

Complex

$500 – $2,000+

A full macro system rebuilt, documented, or moved partly to Power Query.

  • Delivery: 15–30 working days
  • 3 review rounds
  • 30-day warranty

Deliverables

What you receive.

  • Working macros, tested on your own data
  • Plain-English guide to each macro
  • Unprotected, commented VBA code you own
  • A list of steps that could move to Power Query, with prices
  • Fixes covered by a 30-day warranty

Tools

What we work in.

  • Excel VBA
  • 64-bit Office API declarations
  • Trusted locations and macro security
  • Power Query
  • Error handling and logging

Process

How it runs.

  1. Step 01

    Send the file and the error

    A screenshot of the error and a line on what the macro should do is enough. Mutual NDA first if you want one.

  2. Step 02

    Get a fixed price

    Quick fixes get a free written quote within one working day (from $75 / from £60 / from €70 or your local price). Larger macro systems start with the Scoping Sprint.

  3. Step 03

    Fixed, documented, handed over

    50% to start, 50% on handover. You get the working file, the guide and the code.

Frequently asked

Before you book VBA maintenance.

Can't Copilot or ChatGPT fix our macro?

They can suggest code, but an AI chat works from what you paste into it - it does not run the macro against your real files, folders and settings. Suggested code still needs someone to check it before it touches a report.

Our macros are blocked after an update. Is that a bug?

Usually it is security working as designed: Microsoft blocks macros in files from the internet by default. We set up a safe way to run them - a trusted location or a signed file - rather than switching protection off.

Should we replace VBA altogether?

Not always. Macros that only import and clean data are often better as Power Query. Macros that format, email or drive other apps usually stay as VBA. The quote says which is which.

Can you maintain the macros every month?

Yes. After the warranty, the optional Care Plan covers small change requests each month, and bigger changes get their own fixed quote.

Related: Excel VBA & macros · Inherited spreadsheet takeover · Excel VBA vs Power Query

Start with a Scoping Sprint

Send the error. Get the fix price today.

Tell us what the macro should do and what happens instead. We reply within one working day with a fixed price in your currency.

Replies within one working day, usually the same day

Calls 9am–7pm IST, Mon–Sat · How a project works

Service standards

Six rules on every Excel service project.

Project rules, not marketing copy. The same six on every dashboard build, audit, macro, model and clean-up.

15% OFF

15% off your first project

Start with the $99 Scoping Sprint - credited in full to your build.

View more

15% off the build fee of your first project. Mention it when you book; the Scoping Sprint is still credited in full.

The Scoping Sprint gives you a written diagnosis and a fixed price for your build in 2 working days.

Not ready yet? · Free

Free 10-minute Excel audit

Seven checks on your workbook, results in writing within one working day.