Return to VBA Code Examples

VBA – Test if Workbook is Open by Workbook Name

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