John M. Status: Offline
EdinburghUnited Kingdom
100% Job Success
Expert-Vetted

VBA expert | Excel, Word, Outlook, PowerPoint | 26 years' experience

Are you looking for a reliable developer who guarantees high-quality results, stays within budget, and maintains excellent communication throughout your project? Look no further! Why Choose Me? I am dedicated to delivering a top-notch end-product that meets all your project requirements. Here's what you can expect: • Thorough Testing: All functionality will be rigorously tested before delivery to ensure it meets your specifications. • Comprehensive Documentation: I will provide clear usage and installation instructions. If preferred, I can demonstrate the functionality to you. • Cost-Free Fixes: Any issues arising from my errors will be addressed at no additional cost. Budget Assurance. I offer transparent pricing: • Fixed Price: If we agree on a fixed price, that’s the exact amount you’ll pay. If I underestimate the work involved, that’s my responsibility, not yours. • Hourly Rate: For hourly projects, I’ll provide a clear estimate of the hours required. Communication Is Key. From the outset, I prioritize clear communication: • Requirement Clarification: I will engage in a detailed Q&A to ensure your needs are fully understood. • Enhancement Opportunities: I’ll identify potential enhancements you may not have considered, leveraging my expertise as a specialist in Microsoft Office applications and VBA. • Limitations Awareness: I’ll inform you about any limitations, in VBA or otherwise, that may impact your requirements. • Support Needs: I will clarify any information I need from you, such as details about your IT environment and sample data for testing. • Progress Updates: I’ll keep you informed throughout the project and be available for any questions during installation, testing, and first use. My Expertise. I possess extensive experience in Excel, Word, Outlook, and PowerPoint ... with and without VBA macros ... including: • Add-ins: Create complex automations with custom ribbon controls, context menus, shortcuts, and more. • Ribbon Customization: Tailor the ribbon with buttons, checkboxes, and dropdowns to enhance usability. • Custom Forms: Develop "UserForms" for efficient data input and display. • Office Integration: Automate processes across applications, such as generating Word documents or PowerPoint presentations from Excel, sending (or responding to) emails via Outlook. Excel-Specific Skills: • Task Automation: Streamline repetitive tasks, transform and summarize data, scrape data from websites, create complex formulas, and develop drop-down lists and PivotTables. • Dashboards: Design interactive dashboards including Charts, Sparklines and Tables, with real-time data updates and user controls such as Slicers and Timelines. • Data Manipulation: Expert in ETL processes, merging, and transforming data from multiple sources. • Custom Formulas: Develop unique calculations and functions with and without using VBA. Word Expertise: • Document Automation: Implement automated actions for document events (opening, closing, saving, printing, etc.) and custom shortcuts. • Text and Formatting: Mastery over text manipulation, styles, and complex document structures. • Custom Forms: Utilize various controls for user input. Outlook Proficiency: • Automation: Automatically manage emails, attachments, tasks, and calendar events. • Data Extraction: Export email, calendar and task data to other Office applications for reporting. PowerPoint Skills: • Presentation Automation: Execute custom actions and automate slide management. • Design Manipulation: Enhance presentations through effective shape and text formatting. Quality Code. My VBA code stands out for its quality: • Thoroughly Tested: All code is tested in the development environment at multiple levels (unit, integration, system). • Comprehensive Comments: My code includes clear comments for easy maintenance. • Robust Error Handling: I implement comprehensive error handling to facilitate quick fixes. • Ownership: You will own the code, which will be unlocked and free from restrictions. • AI-Enhanced Development: I leverage Artificial Intelligence to support coding efficiency and quality. • Reusable Libraries: I utilize libraries of pre-tested procedures, modules and classes to minimize development time and maximize code quality. Proven Track Record I invite you to read my reviews on Upwork, where every client has expressed satisfaction with my work. With a "Top Rated Plus" status and a 100% "Job Success Score", I am committed to excellence. Let’s Connect! I look forward to discussing your project and helping you achieve your goals.
Work history

John M. has more jobs. Create an account to review them
Skills

Skills

Testimonials

Endorsements from past clients

"I first worked with John in 2020, and I left very positive feedback then, but I feel the need to update that review. I can't tell you how useful is the work he did in VBA for me. He produced some very complex Word macros that I literally still use every week. The complexity is in the VBA code, but for the user (me) it is simplicity itself. I push a button and John's macro set produces five very different versions of a document (a word puzzle). Over the years, I have just come to appreciate how splendid his work was for me. There is some robust error handling I didn't even ask for, for example. Of course, I have made errors over the years, and suddenly I see messages John built in to help me avoid a problem. HIRE THIS MAN! You will congratulate yourself for working with a real pro."

Michael B.
Jun 2024

Verified


"I employed John create a complicated Word Macro to insert images downloaded from the Internet throughout a document template. John was a pleasure to work with and undertook the work quickly and efficiently and the macro works perfectly. I recently had some different work undertaken on the same template by a different developer. The developer saw Johns work and commented on how well it was written even going so far as to say "it was like a work of art", high praise from another developer. Should the need arise I will be using Johns services again."

Matt W.
Dec 2023

Verified


"I've worked with John on multiple successful projects dating back to 2021. John is incredibly knowledgeable in all things Microsoft VBA, and I've never worked with a more meticulous, thoughtful programmer. The systems he's built are still in place today, and hes always quick to provide additional support where required. I wouldn't hesitate to work with John again and would recommend his services to anyone looking for a reliable, professional VBA programmer! Thanks John."

Scott A.
VBA, Word and Excel automation Aug 2023

Verified