Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Created a macro to export a SheetObject to txt/csv. I would like to export the object without headerrow. Any suggestions on how i could change the Macro to do so?
Current Macro looks like this:
Sub
set
sObject = ActiveDocument.GetSheetObject("CH67") SR39sObject.Export
\\filename.txt",";"
End
Sub
i am also interested in this solution, many customers define flat files atructured with no headers...
Hector
There is a very simple workaround: cut the headers from the file after the export. For example file data.txt like this :
Product,Region,Value
one,a,234
one,b,54
one,c,54
three,a,635
three,b,891
Have a batch file containing
type data.txt | find /V "Product,Region,Value" > noheader.txt