Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
How I export only the header? Is a property of the object (t2)?
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