Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this:
SUB ExportChartToCSV
SET objChart = ActiveDocument.GetSheetObject("SAMPLE_ORDER")
objChart.Export "C:\Output\Inventory Manager\Data.CSV", Chr(9)
END SUB