title: VBA Workbook.Open(File) returns Nothing
body: <p><strong>EDIT:</strong> <em>After lots of help and not having a clue what's going on, it worked using a different method of opening (<a href="https://stackoverflow.com/a/44185775/8037946">see @JohnMuggin's help below</a>)--so I un-commented my original code and suddenly it works.</em></p>
  
  <p>I've only found one other instance of <code>Workbook.Open("file")</code> returning nothing <a href="https://stackoverflow.com/questions/7693530/excel-vba-cant-open-workbook">(Link to Q)</a>. However, their problem was because of calling <code>Workbook.Open("file")</code> in a user-defined function (to my understanding). Here, I am calling it in a <code>Sub</code>, but am having the same issue and can't find a solution. I am using Excel 2013.</p>
  
  <pre><code>Private Sub CommandButton2_Click()
  
  'Set variables
  Dim wb As Workbook 'Workbook to open
  Dim wbR As Worksheet 'This is the raw data on the new workbook
  Dim wsL As Worksheet 'Worksheet in current file
  Dim myFile As String 'File to open
  Dim FilePicker As FileDialog
  
  'Set light chain hit worksheet
  Set wsL = ThisWorkbook.Worksheets(3)
  
  'Optimizes Speed
  Application.EnableEvents = False
  Application.Calculation = xlCalculationManual
  
  'Retrieve Target Folder Path From User
  Set FilePicker = Application.FileDialog(msoFileDialogFilePicker)
  
  'Opens folder-picking window
  With FilePicker
      .Title = "Select a file."
      .AllowMultiSelect = False
      If .Show = True Then
          myFile = .SelectedItems(1)
      Else: GoTo NextCode
      End If
  End With
  
  'If folder is not selected
  NextCode:
      myFile = myFile
      If myFile = "" Then GoTo ResetSettings
  
  'Set variable equal to opened workbook
  Set wb = Workbooks.Open(myFile)
  </code></pre>
  
  <p>The macro continues, but the last line <code>Set wb = Workbooks.Open(myFile)</code> sets <code>wb</code> as <code>Nothing</code>. This does not produce any errors until I call <code>wb</code> farther down in the code.</p>
  
  <p>An earlier line, <code>Set wsL = ThisWorkbook.Worksheets(3)</code>, also sets <code>wsL</code> as <code>Nothing</code>.</p>
  
  <p>I have checked each line and values using the debugger, and have determined <code>myFile</code> is the proper path, file name, and extension.</p>