title: VBA Stuck at Workbooks.Open
body: <p>I am trying to automate a request form where the inputs from the form will transfer to a separate excel sheet</p>
  <p>I have this code but error 91 keeps on showing, what went wrong?</p>
  <pre><code>Dim book2 As Workbook
  
  book2 = Workbooks.Open(&quot;Z:\Requests\Request Form.xlsm&quot;)
  
  emptyrow = book2.Sheets(&quot;Logs&quot;).Range(&quot;A1000&quot;).End(xlUp).Row+1
  
  book2.Sheets(&quot;Logs&quot;).Range(&quot;A&quot; &amp; emptyrow).Value = ThisWorkbook.Sheets(&quot;Request Form&quot;).Range(&quot;J9:K9&quot;).Value
  
  book2.Sheets(&quot;Logs&quot;).Range(&quot;B&quot; &amp; emptyrow).Value = ThisWorkbook.Sheets(&quot;Request Form&quot;).Range(&quot;J12:K9&quot;).Value
  
  book2.Sheets(&quot;Logs&quot;).Range(&quot;C&quot; &amp; emptyrow).Value = ThisWorkbook.Sheets(&quot;Request Form&quot;).Range(&quot;C12&quot;).Value
  </code></pre>