CSV generating 65536 rows only from qlikview using Macro

[VishrantiC]

Hi All,

I got one requirement from client to generate CSV file everyday after report refresh and put it on some shared path.

I wrote Macro code for that but after refreshing the file, it is generating 65536 records only in one sheet and moving other records to other sheet of same CSV file. Can anyone help me to handle this?

I need help as soon as possible.

[Miguel_Angel_Baeyens · Accepted solution]

Office has a limitation on the number of rows that can be exported to Excel on 65k, that limit raised to 1M with the newer versions.

If the code in the macro is leveraging those drivers, updating them should fix it. See for example for more reference: https://www.microsoft.com/en-us/download/details.aspx?id=13255