Button to run from qlikview some VBA Macro for exporting a chart table with more than 65536 rows to excel xlsx format
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.
@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
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.
