Qlikview export to excel issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I was trying to export data to excel using a macro, I have enabled Allow system access and System access in macro script module and also I have checked Give system Access to module script for IE plugin. but still I was getting "Macro Parse failed. Functionality was lost.

Sub ExportToexcel
set vPath = ActiveDocument.Variables("Vexcelpathtostore")
Set ExportObject = ActiveDocument.GetSheetObject("ChatID")
ExportObject.Export vPath.GetContent.String, ";"
End Sub

the reason behind going for macro was , users are exporting more than 1M data from QV 11.20 as per the Qlikview we can only export ~65K rwos to .Xls after that the data will export as .CSV file, when data exported to excel, the numbers are converting into Dates so to avoid it I am trying to export the data to .xlsx with the help of macro.

Hope this information will be help full to provide a suggestion\ solution for y issue.

Error:

can any one help me on this? Thanks in advance ..

Re: Qlikview export to excel issue

m_woolf — Tue, 20 Mar 2018 18:19:42 GMT

You might try putting the path into a variable and using the variable in the export command:

Sub ExportToexcel

set vPath = ActiveDocument.Variables("Vexcelpathtostore")

strPath = vPath.GetContent.String

Set ExportObject = ActiveDocument.GetSheetObject("ChatID")

ExportObject.Export strPath ,";"

End Sub

topic Re: Qlikview export to excel issue in QlikView

Qlikview export to excel issue

Re: Qlikview export to excel issue