Appending an Export macro call to QVD

Mon, 23 Sep 2013 03:45:14 GMT

Hi,

I have been trying to export the contents of a straight table into a QVD file using a macro. While that works fine, I cannot get the append option to work in the ExportEx function. Has anyone found a way to get this to work as advertised?

I can add a date-stamp to the file instead to make the file unique, but then I am stuck with a long list of files which are not necessary. Code being used currently is:

Sub ExportDaysCover(vUnit, vExportObject)

vQVWFile = "D:\Qlikview Dashboards\Regional\Inventory\" & vUnit & "\" & vUnit & " Inventory.qvw"

vExportFile = "D:\Qlikview_QVD\QVExport\Regional\Inventory\" & vUnit & "\" & vUnit & "_Days_Cover.qvd"

Set QV = ActiveDocument.GetApplication

Set QVDoc = QV.OpenDoc(vQVWFile)

QVDoc.GetSheetObject(vExportObject).ExportEx vExportFile, 4, true

QVDoc.CloseDoc

End Sub

I have been searching for how to get around this for a while. Tried the AppendExport function too, but didnt get the desired result. Also tried including all optional parameters to the ExportEx function just in case.

Hopefully I am just missing something obvious!

topic Appending an Export macro call to QVD in QlikView

Appending an Export macro call to QVD