I don't believe there is an option with the API to exclude header rows on export. I notice that, even if you check the "Supress Header Row" on chart properties, the header row still exists on export.
Your batch command should work; it looks like maybe you're missing "type" command in front of the command in your post. Also, the string following the /v must be perfect with case, spacing etc.
type TestFile.csv | find /V "Sort Code,Account Name,Account Number,Amount,Reference,BACS CODE" > noheader.csv
For reference - the only way I could make it work was to export the csv file then kick off a bat file to remove the header. If interested my macro was as follows:
'Download Sheet ojbect data to CSV
set sObject = ActiveDocument.GetSheetObject("TB01")
sObject.Export "C:\download\BIB\TestFile.csv", ", "
'Run Bat File to remove headers
Set obj = CreateObject("WScript.Shell")
obj.Run "C:\download\BIB\test.bat ", , TRUE
Then the script in the BAT file kicks off another bit of script. BAT file content is as follows :
And the vbs file is attached:
(A bit long winded but it worked)
DeleteFirstLine.vbs 891 bytes