Series articles: VBA & MS Office automation
Automate MS Excel, Access, and Outlook tasks with VBA and VBS scripts.
📄 View this series as plain MarkdownFollow the "VBA & MS Office automation" series
They land in your feed reader on their own — no account, no email address, nothing to unsubscribe from. Paste this URL into your reader:
https://www.avonture.be/series/vba-ms-office-automation/rss.xmlNo feed reader yet? Start here — it takes two minutes.
MS Excel - Get the list of references used in your modules →
VBA developer? Stop manually checking references! Use this VBS script to automatically retrieve a list of all VBA references in multiple Excel .xlsm or .xlam files.
October 27, 2025
Export MS Access objects →
Easily version control your MS Access database! Export all VBA code, forms, modules, queries, and reports to flat files using a simple VBS script for GitHub integration.
June 27, 2025
MS Office - Load dropdown from Excel's range →
Load an Excel range into your custom VBA Ribbon dropdown control. This step-by-step tutorial covers the VBA code, Custom UI XML, and named ranges needed for a dynamic solution.
February 22, 2025
VBS - Get list of files and generate a CSV →
Need a file list in CSV format? Use this VBScript to scan a folder, including sub-folders, and output file details like size, date, and owner for easy analysis.
November 28, 2024
Microsoft Outlook - VBA - Save emails as PDF →
Learn how to implement a VBA macro in Microsoft Outlook to easily save selected emails as PDF files to your hard drive, complete with step-by-step installation and usage instructions.
July 10, 2024
VBS - Auto update script →
Automate updates for your VBS (Visual Basic Script) console scripts! Learn how to create a self-updating VBS file that connects to GitHub, checks for new versions, and overwrites itself.
March 19, 2024
How to optimize an existing MS Access database →
Speed up your slow Microsoft Access database with this step-by-step optimization guide. Learn to improve table structure, use indexes, optimize queries, and compact your database for better performance.
March 9, 2024
VBS - Retrieve the list of fields in a MS Access Database →
Use a VBScript to easily retrieve a detailed list of fields from your MS Access database. Analyze field size, type, and actual value length to optimize your database structure.
March 9, 2024
MS Excel - How to call a SOAP web service →
Master calling SOAP web services from MS Excel using VBA. Get the code and a step-by-step tutorial to validate VAT numbers with the VIES service.
February 21, 2024
MS Office - How to create a ribbon in Excel →
Step-by-step guide on creating a custom VBA Excel Ribbon. Use XML and VBA to add your own tabs, groups, buttons, and powerful features to your Excel workbooks.
December 10, 2023