Function to Check If Workbook is Already Open Using Excel VBA

The following Excel VBA function may be used to test if an Excel workbook is currently open. The wbName parameter refers to the full path of a specific file. The function will return true if the workbook is already open.

Leave a Comment