title: Visual Basic, Check if a sheet exists in another workbook
body: <p>I'm really new to Visual Basic and I don't know any python either, I'm trying to write code that is able to check if a worksheet exists in a workbook...</p>
  
  <pre><code>Sub sheetexist()
      If Len(Dir(("C:\My Data\Performance Spreadsheets\[ABCD - Performance.xls]Jun 14"))) Then
          MsgBox "Sheet exist"
      Else
          MsgBox "Sheet does not exist"
      End If
  End Sub
  </code></pre>
  
  <p>ABCD does have the sheet for Jun 14 however the code only returns "Sheet does not exist", is there another way to check for worksheets in other workbooks?</p>