Export data from QVD file to EXCEL file

[#1]

Hello community.

I have a problem.

I want to export data from a QVD file to an Excel file automatically.

I would write a script Qikview or a VB macro that does it.

Please i implore your help.

If someone has already done something like that so I listen him

Thank you

[#2]

If you are using QV9 or later you can use "store" command to write a csv file.

If that is not usefull then you must write a macro.

Steps for the export through macro

1. Load qvd in one qwv file

2. define a table with all the field in the qvd

3. define a macro which must contain:

set obj = ActiveDocument.GetSheetObject("TB01"). "TB01" is the id of the table you created at step 2

obj.ExportBiff "YOUR EXCEL FILE WITH PATH.xls"

4. you must put your macro in the post reload event trigger

[#3]

This is my macro:

sub export_QVD_to_EXCEL
set obj = ActiveDocument.GetSheetObject("TB01")
obj.ExportBiff "COMPTE.xls"
end sub

but the file COMPTE.xls is not created when i reload my qlikview document

The following message is displayed on the macro windows : Objet requis: 'obj'

and this statement are selected : obj.ExportBiff "COMPTE.xls"

Thanks

[#4]

it should work. At least for me works. Can you upload an example qwv file?

[#5]

You can see it in the archive file.

[#6]

you should do a table box in the interface 😛 not a table in the script :P. Look at the .qwv file i attached.

[#7]

thanks

it's ok

but can we not do this without displaying the contents of the table?