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.

Sub TestByWorkbookName()
Dim wb As Workbook

    For Each wb In Workbooks
        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

<<Return to VBA Examples