Skip to content
BackNov 7
John M.
Expert-Vetted

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.

🇬🇧Edinburgh, United Kingdom$60/hr100% JSS5.00 (77)Since Aug 2020

Earnings and projects

MRR
$1.3k

Last 6 months ÷ 6

World#38,668 / 412k
🇬🇧Country#787 / 10.7k
Revenue, last 30 days
$252

Last 6 months: $7.6k

World#77,737 / 412k
🇬🇧Country#1,375 / 10.7k
Total earnings
$134k

Billed in all: $140k

World#27,365 / 412k
🇬🇧Country#626 / 10.7k
Per project
$1.5k

$7.6k in the last 6 months

World#93,394 / 412k
🇬🇧Country#2,027 / 10.7k
Projects, last 6 months
1
0% fixed100% hourly
World#128,092 / 412k
🇬🇧Country#2,874 / 10.7k
Projects in all
87

Across 94 contracts

40% fixed60% hourly
World#33,169 / 412k
🇬🇧Country#819 / 10.7k

Earnings, last 30 days

$140k+$252 earned in the last 30 daysBilled in all, before Upwork's fee · drag across the chart to see what was earned in any stretch
$139.6k$139.8k$140.0kOct 8Oct 23Nov 7

Skill rankings: Top 7% in Microsoft Word

Ranked by MRR among everyone on Upwork with the skill.

  1. #12Macros103 freelancers · 🇬🇧 #3Top 12%
  2. #15Spreadsheet Macros118 freelancers · 🇬🇧 #1Top 13%
  3. #21Microsoft Outlook Development139 freelancers · 🇬🇧 #1Top 15%
  4. #31Spreadsheet Automation347 freelancers · 🇬🇧 #3Top 9%
  5. #31Macro Programming285 freelancers · 🇬🇧 #2Top 11%
  6. #56Visual Basic703 freelancers · 🇬🇧 #3Top 8%
  7. #80Excel Macros900 freelancers · 🇬🇧 #4Top 9%
  8. #95Spreadsheet Software1,261 freelancers · 🇬🇧 #2Top 8%