A reference to an open workbook doesn't include the path.
![]()
Const sPath As String = "C:\Test\" Const sWkb As String = "mybook.xls" If WorkbookIsOpen(sWkb) Then Workbooks(sWkb).Select Else Workbooks.Open sPath & sWkb End If ... Function WorkbookIsOpen(sWkb As String) As Boolean On Error Resume Next WorkbookIsOpen = Not Workbooks(sWkb) Is Nothing Err.Clear End Function
Bookmarks