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.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
Sub TestByWorkbookName() Dim wb As Workbook For Each wb In Workbooks 'replace between the quotes with workbook to test for If wb.Name = "New Microsoft Excel Worksheet.xls" Then MsgBox "Found it" Exit Sub 'call code here, we'll just exit for now End If Next End Sub |
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!
Did you find this VBA tutorial useful? Then share it with your friends and colleagues:
Ads