Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I use the following macro to export to csv
SET objChart = ActiveDocument.GetSheetObject("CH461")
objChart.Export "G:\SuiviRupture\Rupture.csv", ""
I need to get the following results
but I got the following results
How to modify the script ?
Hi,
you should use the second parameter of the export function, please try like this:
SET objChart = ActiveDocument.GetSheetObject("CH461")
objChart.Export "G:\SuiviRupture\Rupture.csv", ";"
Let me know if this helps.
Kind regards,
Same problem? Export to csv without delimiter
Hi,
you should use the second parameter of the export function, please try like this:
SET objChart = ActiveDocument.GetSheetObject("CH461")
objChart.Export "G:\SuiviRupture\Rupture.csv", ";"
Let me know if this helps.
Kind regards,
Awesome! Many thanks