Need help with automating and customising Excel, Word, Outlook or PowerPoint?

Whether you need a quick fix in under an hour or a major project over a number of months, contact me to discuss your VBA requirements.

What is VBA?

Home: Welcome

Services

Automate repetitive tasks: transform and summarise lists of data, scrape data from the web, add multiple formulas at once, apply formatting to multiple cells / sheets, automatically generate PivotTables, …
Dashboards: automatically update data from the source and update charts, sparklines and tables; make dashboards interactive with Slicers, Timelines and other controls
Extracting, transforming and loading data: aggregating, merging, aligning data from one or multiple tables
Custom formulas: use VBA, or LAMBDA(), to perform calculations that are not built into Excel - sum cells based on format, custom array sorts, lookups, manipulate text, fixed random values, …
Add-ins: add functionality to Excel to perform complex automations including ribbon/menu buttons, right-click shortcuts, keyboard shortcuts etc
Ribbon customization: from individual buttons, checkboxes, drop-downs, image galleries up to entire groups and tabs … either customising existing ribbon tabs or adding new tabs to the ribbon
Custom forms: for input and display of data
Link with other Office apps: automatically send (or respond to receiving) emails via Outlook, generate Word documents and PowerPoint presentations
Templates: planners, timesheets, trackers, budgets … with and without macros

Document automation: carry out custom actions when a document opens, closes, is saved, is printed or at the press of a button, keyboard shortcut etc
AddIns (aka Global Templates): add functionality to Word to perform automations on any open document
Macro-enabled Templates so that VBA can function within multiple documents
Text manipulation, formatting, styles, page setup
Tables, headers, footers, hyperlinks, bookmarks, pictures, shapes, text boxes, fields, building blocks
Custom forms using FormFields, ContentControls or ActiveX controls
Ribbon customization: from individual buttons, checkboxes, drop-downs, image galleries up to entire groups and tabs … either customising existing ribbon tabs or adding new tabs to the ribbon
Link with other Office apps: automatically send (or respond to receiving) emails via Outlook, generate Excel files from Word documents or tables, transform Word documents into PowerPoint presentations

Presentation / slide automation: carry out custom actions when a presentation or slide opens, closes, is saved, is printed or at the press of a button, keyboard shortcut etc
AddIns: add functionality to PowerPoint to perform automations on any open presentation or slide
Macro-enabled Templates so that VBA can function within multiple presentations
Shape and text manipulation, formatting, styles, page setup
Ribbon customization: from individual buttons, checkboxes, drop-downs, image galleries up to entire groups and tabs … either customising existing ribbon tabs or adding new tabs to the ribbon
Link with other Office apps: automatically send (or respond to receiving) emails via Outlook, generate Excel files from slides, transform PowerPoint documents into Word presentations

Automatically respond to emails, send replies, download, save and/or operate on attachments, extract text from subjects, email bodies and update Excel, Word or other files
Take actions when calendar appointments are due or finished, when tasks are due
Extract lists of calendar appointments, tasks and emails into Excel, Word or PowerPoint
Send emails via Outlook from other Office applications including custom recipients, subjects, body text, embedded images and attachments