Excel VBA functions to break all external references and delete defined names containing external workbook references.
Excel VBA utility function to test if a workbook is already open.
Excel VBA utility function to test if a file exists.
How to programmatically refresh external data lists and pivot tables in Excel using a VBA macro.
How to calculate the quarter number for a given date in Excel.