VBA on sale
Code, tutorials, ideas, hints and tips about VBA
Skip to content
VBA pills for free
Click on an image to download the file
How to create a whole tree of folders, both on local and network drives.
How to take a screenshot of the active window, and save it as a .BMP.
Next record ID
How to determine the ID of the next record that will be stored in a table.
How to open the Windows Magnifier. Special thanks to my good old friend and colleague
Date and Time functions
A collection of date and time functions.
Most recent file
Find the most recent file in a folder, either by creation date or by modification date.
File name parsing
Split a file name in path, name and extension (or combinations of the three).
Make Office talk!
Use Microsoft Speech voices to read text in your Office application.
Send message via Whatsapp
Send a message using Whatsapp. Thanks to Aldir Oliveira from the LinkedIn group "Access and VBA" for suggesting this pill.