Advanced VBA Macros in Microsoft Excel is an advanced course covering class modules, Excel add-ins with a custom Ribbon tab, safe distribution, and using VBA to create Word documents and PowerPoint slides from Excel data. It suits people who already write intermediate VBA and those who share macros with a team, and you leave able to build your own reporting add-in.
Once the macros you write are used by several people, the problems change. Users accidentally delete or edit macros, code has to be copied into every file, there is no easy menu to run it, and data still has to be copied from Excel into Word or PowerPoint by hand for every report. Packaging macros as an add-in with your own Ribbon tab, and letting VBA build documents and slides automatically, lets you distribute tools properly and cut repetitive work across programs.
This course starts with structuring a VBA project and using class modules, then turns macros into an Excel add-in (.xlam), builds a Ribbon tab with Ribbon XML and callbacks that change button states, and sets out how to distribute, protect and sign code. You then use VBA to control Word and PowerPoint, creating documents, reading tables from Word and building slides with charts, and review what to know about VBA in Microsoft 365. It finishes with a workshop that builds an add-in producing Word and PowerPoint reports from Excel data. (2 days, 6 hours per day, 12 hours in total, Advanced level.)
Course Details
This is the 2026 edition of the Advanced VBA macros in Microsoft Excel course. It runs for 2 days, 6 hours per day (12 hours in total, 09:00-16:00), as lectures with hands-on coding labs in every topic, at Advanced level. It keeps the original core of add-ins, Ribbon tabs and controlling Word and PowerPoint, updated for 64-bit Microsoft 365 and Office 2024, and adds class modules, dynamic Ribbons, distribution and code signing, and what to know about VBScript and the new Outlook. It follows on from Excel with VBA for Microsoft 365. Learners use their own or their company's Office for Windows and take home the course handbook, practice files, sample code and the reporting add-in from the workshop.
Section 1: Lab: Structuring a Large VBA Project
Section 2: Lab: Class Modules
Section 3: Lab: Building an Excel Add-in (.xlam)
Section 4: Lab: A Ribbon Tab with Ribbon XML
Section 5: Lab: A Dynamic Ribbon
Section 6: Lab: Distributing and Maintaining Add-ins Safely
Section 7: Lab: Principles of Cross-Program Automation
Section 8: Lab: Creating Word Documents from Excel
Section 9: Lab: Reading Data from Word into Excel
Section 10: Lab: Building PowerPoint Slides from Excel
Section 11: Lab: What to Know about VBA in Microsoft 365
Section 12: Workshop: An Automated Reporting Add-in
No public rounds are open right now. Join the waiting list and we will contact you first when the next round opens, or ask us on LINE. Or call 02-570-8449 or 088-807-9770
Organise the code in an .xlsm file so it refers to ThisWorkbook for the add-in itself and ActiveWorkbook for the file the user has open. Then use File, Save As and choose Excel Add-in (.xlam), and install it via File, Options, Add-ins, choosing Excel Add-ins in the Manage box, clicking Go and ticking the file. In an organisation, place the file in a trusted location or sign the code with a digital signature so the macros are not blocked.
A tab that travels with an add-in is defined in Ribbon XML (customUI) embedded in the file, describing the tab, groups and buttons, with each button's onAction naming a VBA callback that takes control As IRibbonControl. To enable or disable buttons as conditions change, keep the IRibbonUI object from onLoad and use getEnabled with Invalidate. Adding buttons through Customize Ribbon in Options only affects your own computer.
Use automation: create the target program with CreateObject("Word.Application") for late binding, or reference the Microsoft Word Object Library under Tools, References for early binding with IntelliSense. Then fill content controls or bookmarks in a template, or use PowerPoint.Application to add slides by layout and paste charts. When finished, close the documents and call Quit even if an error occurs, so the program is not left in memory.
Most code works, but some points need checking. Declare statements that call the Windows API need PtrSafe, with LongPtr for pointer values. Code that references VBScript.RegExp should move to the RegExp built into VBA because VBScript is being deprecated, and code that controls Outlook needs classic Outlook, because the new Outlook does not support VBA.
It suits people who have completed Excel with VBA for Microsoft 365 or already write intermediate VBA, people who share macros with a team, and staff who regularly turn Excel data into Word or PowerPoint. You should be able to write subs and functions, use arrays and dictionaries, build UserForms and handle errors, and bring a Windows laptop with Microsoft 365 apps or Office 2024.
Yes. It can be run in-house for your team, with examples adapted to your own work, such as an add-in that bundles the team's shared macros with a company Ribbon tab, or Word reports and slides built from your real data. You can request a quotation from this page, or contact us on LINE @itgenius or by phone on 02-570-8449.
Articles are published in Thai.
Once you can write basic macros, real work soon gets harder. Data runs to tens of thousands of rows, so macros that loop cell by cell become slow; files have to be combined from many folders; totals must be summarised by unique customer code; PivotTables and…
Excel is used in almost every job, from keeping lists and working out expenses to summarising monthly sales, yet many users still retype figures by hand, copy formulas that give wrong results or spend too long setting up pages for printing. Getting the…
Many organisations keep their core data in Excel, from customer and product registers to staff records and sales. As the data grows and several people enter it, the same problems keep appearing: numbers stored as text, duplicates, inconsistent spelling,…
