VBA programming: your macro keeps running, without its author.
We take over the VBA programming of your existing Excel and Access systems: adaptations, extensions, bug fixing and documentation, without the original author.
Third-party legacy code
We work through grown VBA code in a structured way, with or without documentation.
First assessment free
The file or a screen share is enough for a read on effort and risk.
More than VBA
Python data analysis, web applications and C# desktop apps come from the same people.
What our VBA programming covers.
-
When the developer is gone
The calculation tool has run for ten years, the colleague has left, and nobody dares to touch the code.
More on this
The usual triggers: a macro that breaks after an Office update, new pricing logic inside grown code, a report that crawls at 100,000 rows, and numbers whose origin nobody can explain any more.
-
Adaptation, bug fixing, documentation
New features and changed business logic go into the existing code. Runtime errors are traced to their cause and tested against production data.
More on this
- Performance: speeding up slow macros, often by orders of magnitude, without touching the logic.
- Interfaces: connecting VBA to SQL Server, Access, CSV and API sources or your ERP.
- Hardening: removing outdated constructs such as ActiveX elements, adding error handling, ordering version states.
- Environments: Excel VBA, Access VBA with forms and reports, Word and Outlook automation.
-
New development in VBA
Possible, and rarely advisable. Microsoft no longer develops VBA actively, it does not run in web and mobile Office, and it scales poorly.
More on this
For new projects we discuss Python for data analysis, with Excel as input and output, a lean web application for multiple users, or a C# desktop app with a database. When existing infrastructure or a short-lived purpose speak for VBA, we build it structured and with error handling.
-
Adapt or replace
While one team works with one file, adapting is cheaper. With simultaneous users, central data and interfaces, an orderly replacement pays off.
See VBA legacy modernization
Is your macro on strike?
Send us the error message and a short description. You get a read on cause and effort, free of charge.
How a VBA adaptation runs with us.
Review
You describe the problem, we look into the code, by file or screen share.
Effort estimate
An effort forecast and our hourly rate, with a check-in before the budget runs out.
Work on a copy
Changes are made on a copy and tested against production data.
Handover and documentation
You get the new version and a description of what changed.
Frequently asked questions about VBA programming.
Do you also take over VBA code written by someone else?
Yes, that is our normal case. We work through third-party legacy code in a structured way, even without documentation. After the review we tell you what state the code is in and what the change costs.
What does a VBA adaptation cost, and how long does it take?
Work on existing code is billed by the hour, because grown code holds surprises. Small changes are often done in one or two days. The free first assessment gives you an effort forecast and our hourly rate.
Do you also program completely new tools in VBA?
We can, and we usually advise against it: Microsoft no longer develops VBA actively, it does not run in web and mobile Office, and it scales poorly. For new projects we discuss Python, a web application or a C# desktop app.
My macro stopped working after an Office update, can you help?
Yes, a classic: changed library references, removed functions, stricter security settings or the move from 32 to 64 bit. Send us the error message and the file.
When does replacement pay off instead of adaptation?
When many users work at the same time, data has to sit centrally, interfaces are required or the changes keep piling up. Our VBA legacy modernization page shows how that runs.
Do you work remotely or on site?
Both. Most VBA engagements run remotely via file handover and screen sharing. On-site appointments work well in Dresden, Leipzig and Chemnitz.
Your VBA system needs a change?
Briefly describe what the tool does and what should change. We reply with a first assessment.
Send a VBA inquiry.
Briefly describe the tool and the desired change. First assessment usually within 24 hours.
We usually reply within 24 hours.
Remote and on site in Germany, Austria and Switzerland. International projects on request.
Related services.
VBA Legacy Modernization
When adapting is no longer enough: migrating legacy systems.
Learn moreCustom Software Development
Web, desktop and data analysis as alternatives to new VBA development.
Learn moreExcel Courses & Workshops (German)
Getting your team up to speed, from formulas to VBA basics.
Learn more