topic Re: Export and Overwrite Excel in QlikView

Export and Overwrite Excel

Mon, 22 May 2017 15:01:47 GMT

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 — Mon, 22 May 2017 15:39:49 GMT

HI Michele,

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

el_aprendiz111 — Mon, 22 May 2017 16:34:07 GMT

Hi,