Create QVD by macro and buffer prefix

[#1]

Hello everyone ..

I want to create a qvd file for my sheet object like for a calculated table object and a bar chart.

I created a macro

sub CreateQvd

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "C:\abc.qvd",4

end sub

and added a action to OnPostReload Trigger to run this macro.. But there is no qvd file generate for that table chart.

Did I make any mistake,if anyone has any idea please share,it will very helpful.

And one more thing how to create qvd automatic by Buffer Prefix.

Because I wrote a script

Buffer Load * from Emp.xls;

but it wont create any qvd file. Please make this clear to me.

Thank you in advance..

[ashfaq_haseeb]

Hi,

Look at the below post.

http://community.qlik.com/docs/DOC-5661

Regards

ASHFAQ

[ashfaq_haseeb]

Hi,

Look at the attache application even.

Regards

ASHFAQ

[#4]

if u impose Buffer load it will create the  QVD automatically in specific path...u should check ur default path......go to settings>user preferences>locations>QVD path

[#5]

Hi,

Let vRutaDoc = 'C:\';

You can to use this:

ExcelDatos:

Buffer Load * from Emp.xls

Store * from ExcelDatos into $(vRutaDoc)abc.qvd;

I hope it help you.