The VBA Help - customisation and automation of Excel, Word, PowerPoint and Outlook

I solve clients' complex needs with innovative and high-quality Excel, Word, Outlook and PowerPoint solutions using VBA macros. This increases clients' effectiveness and efficiency and frees up time to focus on core business.

I have been working with VBA for over 20 years and have a thorough understanding of how to get the best out of it to produce automation and customisation solutions. I have completed VBA projects ranging from a dozen lines of code in a single Excel workbook up to many tens of thousands of lines across multiple Office applications.

Currently I am building-up my presence on Freelancer having spent a number of years working on Upwork. To see more about me and my 'VBA history' and experience, please see my Upwork portfolio https://www.upwork.com/freelancers/thevbahelp, my StackOverflow profile https://stackoverflow.com/users/11318818/johnm and my website https://www.thevbahelp.com/.

Unlike many other developers, my high-quality code:
• Has been fully tested
• Comes with comprehensive code comments to aid future maintainability … by myself or other developers
• Has across-the-board error handling so that, if the worst happens, errors can be identified, located and quickly fixed
• Is unlocked and without time restriction

Recent projects completed include:
• Product pricing tool – update and maintain a macro-enabled Excel workbook that is used by a large (1,300 employees) US-based IT firm to generate quotes for its products for end-customers (50+ individual products each with various options for sub-products, service levels, duration, new/addon sales types and discounts)
• Excel and Outlook automation for bathroom fittings company – Outlook receives, and extracts specific data from, e-mails and passes it to Excel. Excel performs various calculations and creates a 'Quote' PDF file and then automates Outlook to reply to the original e-mail with the Quote attached
• Financial modelling – a UserForm to control a financial model allowing staff to input only valid inputs, and so assuring valid results
• Robotic machine targets – an Excel AddIn to generate a list of robotic vending machine target location points based on user-entered product details
• Excel VBA data transformation – sorting, filtering, copying, grouping, summarising and pivoting data for hotel bookings, discounts and vouchers at the click of a button
• Extract headings into Excel – headings in any Word document are extracted and loaded into an Excel table in a structured manner
• Employee attendance tracker – employees working weekly and fortnightly shifts needed a tracking and absence monitoring tool

Client reviews for these and other projects are available in my Upwork portfolio at the link given above.

Clients complement me on my attention to detail, my creative and intuitive solutions and my communication and collaboration skills.

I’m used to working to deadlines, I’m hard-working and reliable, I speak English natively.

Get in touch to discuss your project!

Work Terms

I typically work Monday to Friday, early starts and finishes but can be flexible especially if you work in a different timezone.

I prefer hourly paid contracts but I'm willing to discuss fixed price contracts for a specific scope of work.

My style of communication is initially to ensure that project requirements are clearly understood before work starts and then to send regular updates on work progress. When a project is complete I am happy to review installation procedures and ensure users are comfortable with all work before any final sign-off.

Attachments (Click to Preview)