John M.

VBA Developer | Excel, Word and Outlook Automation | Microsoft MVP

I'm a VBA developer with over 25 years building macros and automation across Excel, Word, Outlook and PowerPoint. Word and Outlook automation is a more specialised corner than Excel, and it's where a lot of my biggest projects sit, so you get real depth where it's hard to find. I'm a Microsoft MVP and Expert-Vetted on Upwork (the top 1%), with a 100% Job Success Score, $100K+ earned and five stars from every client who's left a review. I also build with AI in my corner. I use Claude to work through options faster and pressure-test my code, so you get quicker delivery with no drop in quality. What you can expect: Guaranteed quality. Every solution is rigorously tested before delivery, at unit, integration and system level. Any error on my part is fixed at no cost to you. Predictable costs. Fixed price means fixed price. If I underestimate the work, I absorb the difference. Hourly projects always include a clear upfront estimate. Clear communication. I start with a thorough Q&A to fully understand your requirements, including enhancements you may not have considered. I flag limitations early, keep you updated throughout, and I'm available during installation and first use. You own the code. Delivered fully unlocked, with no restrictions and no lock-in, ever. It's well-commented with robust error handling, so it's easy to maintain, adapt, or hand to another developer if you ever need to. Excel - Task automation, data transformation, and ETL - Dashboards with charts, sparklines, slicers, and timelines - PivotTables, Power Query, complex formulas, and UDFs - Drop-down lists, data validation, and conditional formatting Word - Document automation and event-driven macros - Styles, complex formatting, and document structures - Custom forms and user input controls - Automated actions triggered by document events (open, save, print, close) Outlook - Email, attachment, calendar, and task automation - Automatic rules and responses based on email content - Data extraction and export to Excel for reporting PowerPoint - Presentation automation and slide management - Advanced shape and text formatting - Automated slide generation from Excel data Add-ins & Cross-App Integration - Complex VBA add-ins with custom ribbon controls, context menus, and shortcuts - VBA-powered cross-application automation: generate Word docs or PowerPoint slides from Excel, send Outlook emails from any Office app - Reusable libraries of pre-tested modules and classes to maximise quality and minimise delivery time Want to discuss your project before committing? Send me an Upwork message or book a consultation, no obligation. Every conversation starts with me listening to what you actually need.