Qlik Macro

[niranjana]

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

[rwunderlich]

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

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com