title: Run time error (9) when defining a Workbook
body: <p>Good morning,</p>
  
  <p>I'm trying from my master excel workbook to read into another workbook.
  Anytime I try to set that workbook into a variable (book2) I get the error "Run-time error 9: Subscript out of range".
  Here the code I wrote:</p>
  
  <pre><code>Const path As String = "\\prod\root\v_drive\IBS\ENG_Data\Jobs\NOETIX_EXPORT_FOR_COMMUNICATION_TOOL\PPM TOOL - Order Level.xls"
  
  Sub Import_Data()
  Dim lookFor As String
  Dim srchRange As Range
  Dim book1 As Workbook: Set book1 = ThisWorkbook
  Dim book2 As Workbook: Set book2 = Workbooks(path)
  End sub
  </code></pre>
  
  <p>If instead of the line that gives me an error I enter the code</p>
  
  <pre><code>Workbooks.Open (path)
  </code></pre>
  
  <p>the files opens without any problem (this should mean that the path is correct and the file exists..). I tried having the file open and closed, on my local drive or in a remote location but I keep having the same error.
  Do you have any idea what i may be doing wrong?
  Thanks in advance for your help.</p>