topic Button to run from qlikview some VBA Macro for exporting a chart table with more than 65536 rows to excel xlsx format in QlikView

Button to run from qlikview some VBA Macro for exporting a chart table with more than 65536 rows to excel xlsx format

moniquen17 — Thu, 10 Oct 2024 12:55:47 GMT

Hi Everybody

Can you please give some Macro VBA Script example for exporting from QlikView (Version 12.10.20800.0) a chart table with more than 65536 rows to excel xlsx format. This macro should be run by pressing some button in QlikView. The xlsx exported file should be saved in c:\temp folder.

Thanks

Monique

Re: Button to run from qlikview some VBA Macro for exporting a chart table with more than 65536 rows to excel xlsx format

David_Friend — Thu, 10 Oct 2024 14:00:22 GMT

@moniquen17 I am not aware of a method to do that via a script...generation of XLS is typically accomplished via NPrinting...also just FYI that 12.10 is pretty old, it went out of support way back in 2019

the 65k rows is a limitation of XLS, will need to switch to XLSX to go higher

Re: Button to run from qlikview some VBA Macro for exporting a chart table with more than 65536 rows to excel xlsx format

moniquen17 — Thu, 10 Oct 2024 14:12:58 GMT

Hi David

Yes, indeed 65k rows is a limitation of XLS. This is the reason why I am interested in a macro-VBA script to export chart with huge data to xlsx format and not csv as it is the case when using the option "sending to excel" from QlikView.

Anyway, thanks for helping here

Best Regards,

Monique