title: Saving Excel file as CSV while excluding header in VBA?
body: <p>I have written  the following code:</p>
  <pre><code>Sub create_talpo_kiint_csv()
      Dim FileName As String
      Dim PathName As String
      Dim ws As Worksheet
  
      Set ws = ActiveWorkbook.Sheets(&quot;SheetName&quot;).range(&quot;B2&quot;, range(&quot;B2&quot;).End(xlToRight).End(xlDown)).Select
      FileName = &quot;test.csv&quot;
      PathName = Application.ActiveWorkbook.Path
      ws.Copy
      ActiveWorkbook.SaveAs FileName:=PathName &amp; &quot;\&quot; &amp; FileName, _
          FileFormat:=xlCSV, CreateBackup:=False
  End Sub
  </code></pre>
  <p>The goal is to save the excel file as csv while excluding the header. However, the code above is not working. What should I do to fix it?</p>