Export and Overwrite Excel

[#1]

Hi Qlikers,

I have a big problem with a macro.

I want to export an object (CH01) but i can't overwrite it.

The macro is this:

SUB ExportExcel

set sObject1 = ActiveDocument.GetSheetObject("CH01")

sObject1.Export "E:\MyDoc.csv", ", "

end sub

I need to overwrite "MyDoc" everytime that the Qlik file is reloaded.

Thanks in advance.

[tamilarasu]

HI Michele,

The below attachment is working fine. I am able to overwrite the existing file.

[el_aprendiz111]

Hi,