How to store a table box into qvd using action macro in button ?I tried script like below :
sub StoreTB01TableToQVDset obj = ActiveDocument.GetSheetObject("TB01")File = ActiveDocument.Evaluate("TB01.qvd")obj.Export File, 4end sub
When I click test in the macro window, popup appear 'Cannot open file - for writing'
What should I do?
Thank you for you suggestion
Sub QVDExportset st = ActiveDocument.GetSheetObject("TB01")File = activedocument.Evaluate("'Path\table.qvd'")st.Export File, 4End Sub
I tried your suggestion, qvd successfully generatedBut, when I opened it, in QlikView for data loadingThe separator became wrong, please see my attachment
Is there any other parameter in function Export, to set the separator?
Thanks a lot
Honestly, I am not an expert on Macros. I tried searching in the community and couldn't find the exact solution.
Basically, that export is missing the XML header part.
Alternatively, you can export the complete table box into an XML file and then read it.
set table= ActiveDocument.GetSheetObject("TB01")
I have tried exporting chart objects into qvd and that worked fine
set obj = ActiveDocument.GetSheetObject("CH01")
obj.ExportEx "Desktop\chart.qvd", 4