VBAEnabled: Did User Click “Enable Contents”?
With Excel, users have to click “Enable Contents” when they first open a file with VBA embedded. This function allows you to check if they did so.
Excel
PathToChrome: Get the Correct Path to Google Chrome
Find the correct path to Google Chrome, which depends on your device.
MoveExcelFile: Moves an Excel File
Move an Excel file from one location to another, and even change the filetype.
CreateFolderStructure: Create Multiple Layers of Folders
Create a folder and all necessary parent folders.
PutUsername: Dynamically Put Username Into String
The magical way to put your username into a cell or string.
Worksheet_FollowHyperlink: Activate Excel VBA Using Hyperlink
I’ve seen shapes placed on Excel sheets used to activate an Excel VBA. A more elegant solution is to use text hyperlinks.
Excel Number Formatting for Dates
In the big world we live in, there are many different ways to write the date. Learn more about my preferred style and how to treat year in an internationally-friendly way.
SaveSheetAsPDF: Save an Excel Sheet as a PDF
When distributing reports to your audience, consider providing a PDF file rather than an Excel file. On your journey to automate your analyses using VBA, there’s an easy way to save an Excel Sheet as PDF.