title: VBA returns error 1004 while trying to copy worksheet to another workbook
body: <p>I have question: while trying to copy a worksheet to another workbook I get an error (error  1004 ).
  This is my code:</p>
  
  <pre><code>Sub CopyWorksheet()
  Application.ScreenUpdating = False
  Dim BonusRatesWB As Workbook
  Dim appExcel  As Application
  
  Set appExcel = New Application
  appExcel.Visible = False
  Set BonusRatesWB = appExcel.Workbooks.Open("D:\Documents\Overdraft\OVERDUE customers\HARD COLLECTION\Hard Collectors Bonus Calc\BonusRates\ProblemLoansOfficerBonusRates15Sep2017.xlsx")
  With ThisWorkbook
      BonusRatesWB.Sheets(1).Copy After:=.Sheets(.Sheets.Count)
  End With
  BonusRatesWB.Close
  
  appExcel.Quit
  Application.ScreenUpdating = True
  </code></pre>
  
  <p>End Sub</p>
  
  <p>I assume there's something missing/wrong with my object variables, but I was unable to figure it out. Help would be highly appreciated.
  Many thanks in advance.</p>