title: Copying Worksheet into another folder
body: <p>I am writing a code to copy sheet8 from workbook with the name xyz.xlsx present in cell P2 of sheet1 and paste it in another folder folderX. I have not written the paste-code till now. </p>
  
  <p>I am getting:</p>
  
  <blockquote>
    <p>Runtime error '424' Object required</p>
  </blockquote>
  
  <p>The snippet of the code:</p>
  
  <pre><code>Sub file_name()
  returnVal = Sheet1.Cells(2, 16).Value
  Dim FPath As String
  FPath = Application.ActiveWorkbook.Path
  Application.ScreenUpdating = False
  Application.DisplayAlerts = False
  Sheet8.Copy
  Application.ActiveWorkbook.SaveAs FileName:=returnVal &amp; “.xlsx”
  Application.ActiveWorkbook.Close False
  Application.DisplayAlerts = True
  Application.ScreenUpdating = True
  End Sub
  </code></pre>
  
  <p>I am very new to macros.</p>