Export to excel data more than 65,536 rows

[#1]

Hi All,

I want to export the data in excel for which I am using macro :

SUB Export

SET Doc = ActiveDocument

Doc.GetSheetObject("TB83").ExportBiff "E:\Qlikview\test.xls"

end sub

The above script works only for xls, but i need it to work for xlsx as data now has more than a million rows .

Please note users dont need data in csv format.

[Andrea_Ghirardello]

see the following discussion:

Export Macro

[Gysbert_Wassenaar]

Perhaps this discussion helps: http://community.qlik.com/thread/89308