Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am exporting data into Excel thru Qlikview Macro code and file size higher like 15-20 MB.
Can we convert to .xlsb (Binary Excel format) instead of .xls (Excel Format)?.. Anyone please help
BR's
Narsingh
If you just export objects to excel you couldn't store them as xlsb but if you creates a new excel instance and within there a new workbook and copied your objects there it should work to save it in various file-formats and probably also in xlsb. I think this should be helpful for you: Macro - Export Multiple Charts From Container To Excel.
- Marcus