Section
VBA and Excel
The pack is still finished in Excel. The modules here are standard .bas files: import them, save as .xlsm, and run them yourself. Nothing on this site runs when a workbook opens.
Posts
-
Start here VBA · Excel
Month-close checks
Flag a blank reporting period, empty Input_ drivers and #REF! or #N/A errors before the pack goes out.
-
VBA · Outlook
New Outlook email macros
Why New Outlook breaks Excel VBA email macros, and a send-or-save fallback that keeps month-end mails moving.
More VBA modules are on the way. Until then, the Jedox and Snowflake sections show where the numbers in the pack come from.