Qlikview export to excel issue

[Anonymous]

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 ..

[m_woolf]

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