title: Copy method of worksheet class failed
body: <p>I have a little program in PPT that makes copy of the sheets in Excel. It works when Excel file is open; however, if I close the Excel file and run the program in PPT, it says run time error (copy method of worksheet class failed)</p>
  
  <pre><code>Dim OWB As Excel.Workbook
  Set OWB = GetObject(ActivePresentation.Path &amp; "\Test.xlsx")
  OWB.Sheets(1).Copy after:=OWB.Sheets(1)
  </code></pre>
  
  <p>I run this in PPT without a problem when the Excel file "Test" is open; If I close the Test excel, this code gives me this error.</p>
  
  <p>Any help would be appreciated!</p>