Export 2 objects in 1 cvs file with header

[Anonymous]

Hi,

To solve my problem I use this code:

function GenerateCSV

          Set t1 = ActiveDocument.GetSheetObject("TB01")

          t1.Export "tables.csv", ";"

          Set t2 = ActiveDocument.GetSheetObject("TB02")

          t2.Export "tables.csv", ";",, TRUE

end function

This work fine but the second header is not in the file and I have to have the 2 header in the file.

I am new in Qlikview and I don't know where can I found information about VBScripting for QV.

Thanks!

[ecolomer]

You can see ...

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

[marcus_sommer]

A very good overview about qlikview-vbs which included the objectmodel, examples and parameters could you find in APIGuide.qvw in our intsall-folder by automation.

If your code worked unless the header from table 2 you could try it with an third export between your tableboxes which only contained the header.

- Marcus

[Anonymous]

How I export only the header? Is a property of the object (t2)?

[marcus_sommer]

You could use a textbox or chart-table for this in which you the header from t2 manually creates. This object could also be hidden directly or in a specialized hidden sheet for prints and exports.

- Marcus