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 →
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.
Free Self-Serve Excel Tools
Interactive in-browser calculators and diagnostics. No sign-up, no email required.
Workbook Compare
Drop two versions of a file and see every changed cell and formula, inserted rows, and formulas someone typed over.
Workbook Map
See how your sheets feed each other as a diagram, with links to other files, hidden feeders and circular links flagged.
Formula Explainer
Paste any formula and read it in plain English, step by step in the order Excel calculates it.
Related
Keep reading
Service
AI-Built Workbook Review
A senior check of an Excel workbook built with Copilot, ChatGPT or Claude, with every issue and its fix in a written report.
Service
Excel to Google Sheets Migration
Move Excel workbooks and macros to Google Sheets: formulas rewritten, VBA rebuilt in Apps Script, outputs checked.
Service
Excel Automation
Excel automation services for monthly reports - sales MIS, month-end packs, stock and reconciliations refreshed with Power Query and VBA at a fixed price.
Service
Excel VBA / Macros
Excel VBA and macros for reconciliation, mail merge, PDF export and scheduled refreshes.
Service
Excel Team Training
A live online Excel session for your team, built around your own workbook, with the recording to keep.
Service
Accounting Exports to Excel Reports
QuickBooks, Xero, Sage, Zoho Books or Tally exports into a monthly Excel management report that refreshes in one click.
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.
- 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.
- 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.
- 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.
Calls 9am–7pm IST, Mon–Sat · How a project works