Need help with automating and customising Excel, Word, Outlook or PowerPoint?
What is VBA?
VBA (Visual Basic for Applications ... also known as 'macros') is the programming language used to automate and customise Excel, Word, Outlook, PowerPoint and other Office applications. For more information and background on VBA, see What is VBA.
Why use VBA?
To save time and money. To increase reliability. To complete a complex, multi-step, repetitive task by clicking on a single button to automate and customise Excel, Word, Outlook and PowerPoint. For further detail, see the Services section of this page, just below.
Create VBA yourself?
Make coding with VBA quicker, simpler and less bug-prone. Find declarations, references and TODOs. Cursor history. Better navigation. Rename and other code refactorings. Add this and more functionality to the Visual Basic Editor ... using VBE_Extras
Services
Most of my work falls into the areas below. If yours doesn't, ask anyway ... if it can be done with VBA, I can build it. And now AI-accelerated ... faster turnaround, with the same tested code that you own outright.
Excel
What I build: workbooks that do a day's work in one click.
-
Automate repetitive jobs: transform and summarise data, add formulas and formatting in bulk, generate PivotTables automatically.
-
Dashboards that refresh themselves: live data, charts and sparklines, interactive Slicers and Timelines.
-
Extract, transform and load data: aggregate, merge and align one table or many.
-
Custom formulas and Functions (VBA or LAMBDA) for calculations Excel cannot do out of the box.
-
Templates: planners, timesheets, trackers, budgets ... with or without Macros.
For example, a workbook that turns three hours of monthly reporting into a single button.
Word
What I build: documents that assemble and format themselves.
-
Document automation: custom actions when a document opens, closes, saves or prints ... or at the press of a button.
-
Text, styles and formatting handled in bulk: tables, headers, footers, fields, building blocks.
-
Custom forms using FormFields, ContentControls or ActiveX controls.
-
Macro-enabled Templates so your VBA works across many documents.
For example, a template that builds a formatted client report from your data while you fetch a coffee.
PowerPoint
What I build: presentations that build themselves from your data.
-
Presentation and slide automation: custom actions on open, close, save or print ... or at the press of a button.
-
Slide generation straight from Excel data.
-
Shape and text manipulation, formatting, styles and layout in bulk.
-
Macro-enabled Templates so your VBA works across many presentations.
For example, a 40-slide monthly deck generated from a workbook in seconds.
Outlook
What I build: an inbox that deals with the routine itself.
-
Automatically respond to emails, send replies, and save or process attachments.
-
Extract text from subjects and bodies, and update Excel, Word or other files.
-
Act on calendar appointments and tasks when they fall due or finish.
-
Extract lists of appointments, tasks and emails into Excel, Word or PowerPoint.
For example, a mailbox that files attachments and logs every order into Excel before you have read the email.
Across all four apps
-
Add-Ins that bring your automations to every open file.
-
Ribbon customisation: buttons, drop-downs, galleries ... up to whole groups and tabs.
-
Cross-app integration: build Word documents or PowerPoint decks from Excel, send Outlook emails from any Office app, transform PowerPoint presentations into Word documents.
-
A library of pre-tested Modules and Classes, to maximise quality and minimise delivery time.
Why work with me?
Tested before it reaches you. Every solution is tested at unit, integration and system level before delivery. If something I wrote goes wrong, I fix it at no cost to you.
A fixed price that stays fixed. If I underestimate the work, I absorb the difference. Hourly projects always come with a clear estimate up front.
You own the code. Delivered fully unlocked, well commented, no restrictions and no lock-in ... ever.
I ask first, then build. Every project starts with a proper Q&A so I understand what you actually need ... including improvements you may not have thought of.
And the proof: Microsoft MVP, Top Rated Plus on Upwork, 100% Job Success, and 5.0 out of 5.0 rating from 77 reviews.
“Absolutely in the top rank. HIRE THIS MAN ... he’s that good.”
— Michael Blake
“I've never worked with a more meticulous, thoughtful programmer.”
— Scott Ackerl
How I use AI
I use AI tools (Claude in particular) to speed up the routine parts of development ... research, first drafts of code, building out test cases ... so more of your budget goes on the parts that need real judgement. Everything I deliver is written, reviewed and tested by me. You get the speed of modern tooling with the judgement that over 25 years brings.
Develop VBA yourself?
Make coding with VBA quicker, simpler and less bug-prone. Find declarations, references and TODOs. Better navigation and cursor history. Rename and other code refactorings. Add this and much more to the Visual Basic Editor with VBE_Extras ... and give the editor itself a fresh coat of paint with VBE_Colours.
Tell me about your project
There is no obligation, and every conversation starts with listening, not selling. Contact me directly, or hire me through Upwork if you prefer the protection of escrow and a public track record.