export csv

[Anonymous]

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 ?

[Clever_Anjos]

Same problem? Export to csv without delimiter

[santiago_respane · Accepted solution]

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,

[Anonymous]

Awesome! Many thanks