CSV file to be saved with tab separator value

[divyasivathanu]

Hi, 

I need a CSV file to be saved with tab separator value. But I am not getting the expected result instead the value is getting replaced with '\t' as text.

Please find the code below and let me know what should be corrected.

SUB ExportChartToCSV

SET objChart = ActiveDocument.GetSheetObject("SAMPLE_ORDER")

objChart.Export "C:\Output\Inventory Manager\Data.CSV", "\t"

END SUB

[Frank_Hartmann]

try this:

SUB ExportChartToCSV

SET objChart = ActiveDocument.GetSheetObject("SAMPLE_ORDER")

objChart.Export "C:\Output\Inventory Manager\Data.CSV", Chr(9)

END SUB