Strip different types of characters from a string
A small VBA utility for stripping control characters and other unwanted character ranges from strings.
wazza is awesome
Automatic email account assignment in Outlook
A VBA and Outlook automation approach for choosing the correct sending account when managing multiple email addresses.
Generic function to copy Excel data between workbooks
A VBA function for copying data between Excel workbooks while validating uploaded customer spreadsheets.
2006 Super Fund Performance
A historical report on the Bainsworld Superannuation Fund's 2006 return and share portfolio holdings.
How to tell if an Access Report was printed
A Microsoft Access VBA technique for detecting whether a report was printed rather than only previewed on screen.
Error when referring to Excel sheets collection by sheet name
A VBA troubleshooting note on an Excel Sheets collection error when accessing worksheets by name from Access.
Calculating compound annual growth rate (CAGR)
An Excel user-defined function for calculating compound annual growth rate from a start value, end value, and duration.