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.
VBA
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.