Excel VBA Procedures to Break All External References in Workbook
Excel VBA functions to break all external references and delete defined names containing external workbook references.
Excel
Function to Check If Workbook is Already Open Using Excel VBA
Excel VBA utility function to test if a workbook is already open.
Function to Check If File Exists Using Excel VBA
Excel VBA utility function to test if a file exists.
Refresh Data and Pivot Tables in Excel Using VBA
How to programmatically refresh external data lists and pivot tables in Excel using a VBA macro.
Calculate Quarter Number In Excel
How to calculate the quarter number for a given date in Excel.