Qlik Macro

niranjana — Fri, 08 Mar 2024 17:24:13 GMT

Hi,

I want to write a macro for exporting a straight table to qvd. :

sub ExportEx

set obj1 = ActiveDocument.GetSheetObject("CH01")

obj1.ExportBiff "L:\Reports\IIB_SHALOM\02.QVD\Application_Chart_Final.qvd"

end sub

When I click on "test", it doesnt throw any error.

But when I reload another Qlik app which uses this QvD, I get error like "Qlik File is unsupported or bad".

Note : I dont want to store qvd in script. I must use macro.

Any help is appreciated.

Niranjana

Re: Qlik Macro

rwunderlich — Fri, 08 Mar 2024 19:35:25 GMT

ExportBiff does not create a QVD, it creates an xls file. To export to a QVD, you'll want to use the ExportEx method with a filetype of 4.

obj1.ExportEx "L:\Reports\IIB_SHALOM\02.QVD\Application_Chart_Final.qvd", 4