Excel export macro exporting same object

Anonymous — Fri, 19 Oct 2018 03:40:50 GMT

Hello All,

I have the below macro to export three different objects from my QlikView document. However, on completion of this macro, the contents in all three different excel files are the same.

Filenames are being created as defined in the macro but the content of all is that of one of the three objects exported.

Any help or advise on why the macro is behaving in this manner and what can be done to resolve this is much appreciated.

sub ExportSalesOrder

'Get variable
set vExportFilePath = ActiveDocument.GetVariable("vExternalExportPath")
set vForDate = ActiveDocument.Variables("vProcessDate")

'Set variable
vDate = vForDate.GetContent.String
vExpPath = vExportFilePath.GetContent.String

'Export Summary
CSVFile1 = vExpPath & "\" & vDate & "_Summary.xls"
set obj1 = ActiveDocument.GetSheetObject("SUMMARY")
obj1.ExportEx CSVFile1, 5

'Export Sales
CSVFile2 = vExpPath & "\" & vDate & "_Sales.xls"
set obj2 = ActiveDocument.GetSheetObject("SALES")
obj2.ExportEx CSVFile2, 5

'Export Orders
CSVFile3 = vExpPath & "\" & vDate & "_Orders.xls"
set obj3 = ActiveDocument.GetSheetObject("ORDERS")
obj3.ExportEx CSVFile3, 5

msgbox("Data exported to Excel files")

End Sub

topic Excel export macro exporting same object in QlikView

Excel export macro exporting same object