VBA – Test if Workbook is Open by Workbook Name

Associated Files Download Links


Test if Workbook s Open

Here is some real basic code for testing if a workbook is currently open by testing for a workbook’s name, not the fully qualified name including the path.

I was writing code in a spreadsheet that altered sheets in another workbook, and wanted to make sure workbook 2 was open before the code executed in workbook 1.

VBA Coding Made Easy

Stop searching for VBA code online. Learn more about AutoMacro – A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!

alt text

Learn More!


<<Return to VBA Examples

Did you find this VBA tutorial useful? Then share it with your friends and colleagues: