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.
Accessing Planning Analytics Transaction Log in PAFE
The TM1 Transaction Log records the history of changes to cube values in your database. I’ve taken the liberty to build a Transaction Log Excel App that works with PAFE.