top of page

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?

VBA (Visual Basic for Applications ... also known as 'macros') is the programming language used to automate and customise Excel, Word, Outlook, PowerPoint and other Office applications. For more information and background on VBA, see What is VBA.

Why use VBA?

To save time and money. To increase reliability. To complete a complex, multi-step, repetitive task by clicking on a single button to automate and customise Excel, Word, Outlook and PowerPoint. For further detail, see the Services section of this page, just below.

Create VBA yourself?

Make coding with VBA quicker, simpler and less bug-prone. Find declarations, references and TODOs. Cursor history. Better navigation. Rename and other code refactorings. Add this and more functionality to the Visual Basic Editor ... using VBE_Extras

Home: Welcome
Services

Services

Excel

Excel logo
  • 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

  • Integrate 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

Word

Word logo
  • 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

  • Integrate 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

PowerPoint

PowerPoint logo
  • 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

  • Integrate with other Office apps: automatically send (or respond to receiving) emails via Outlook, generate Excel files from slides, transform PowerPoint documents into Word presentations

Outlook

Outlook logo
  • 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

bottom of page