Articles tagged: VBA / VBScript
Follow VBA / VBScript
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/blog/tags/vba/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 Excel - Connect to a SQL Server database, run a query and get the results - Step by step →
Connect MS Excel VBA to SQL Server with this step-by-step tutorial. Learn to run SQL queries, retrieve data, and output results into your spreadsheet. Docker setup included.
March 16, 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
WinSCP - Visual Basic for Application use →
Automate secure SFTP/FTP file transfers directly from MS Office. Learn how to call the WinSCP DLLs using simple Visual Basic for Application (VBA) code with a practical example.
August 13, 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
MS Excel - Connect to a SQL Server database, run a query and get the results →
Connect MS Excel to SQL Server with VBA. Run SQL queries, inject results directly into your spreadsheet, and preserve formatting. Learn the best method for data refresh or secure sharing.
April 5, 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