topic Qlikview Macro to Save as Binary Excel Format in QlikView https://community.qlik.com/t5/QlikView/Qlikview-Macro-to-Save-as-Binary-Excel-Format/m-p/1259061#M397450 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am exporting data into Excel thru Qlikview Macro code and file size higher like 15-20 MB.</P><P></P><P>Can we convert to .xlsb (Binary Excel format) instead of .xls (Excel Format)?.. Anyone please help</P><P></P><P>BR's</P><P>Narsingh</P></BODY></HTML> Fri, 24 Feb 2017 06:52:42 GMT 2017-02-24T06:52:42Z Qlikview Macro to Save as Binary Excel Format https://community.qlik.com/t5/QlikView/Qlikview-Macro-to-Save-as-Binary-Excel-Format/m-p/1259061#M397450 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am exporting data into Excel thru Qlikview Macro code and file size higher like 15-20 MB.</P><P></P><P>Can we convert to .xlsb (Binary Excel format) instead of .xls (Excel Format)?.. Anyone please help</P><P></P><P>BR's</P><P>Narsingh</P></BODY></HTML> Fri, 24 Feb 2017 06:52:42 GMT https://community.qlik.com/t5/QlikView/Qlikview-Macro-to-Save-as-Binary-Excel-Format/m-p/1259061#M397450 2017-02-24T06:52:42Z Re: Qlikview Macro to Save as Binary Excel Format https://community.qlik.com/t5/QlikView/Qlikview-Macro-to-Save-as-Binary-Excel-Format/m-p/1259062#M397451 <HTML><HEAD></HEAD><BODY><P>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: <A href="https://community.qlik.com/docs/DOC-16364">Macro - Export Multiple Charts From Container To Excel</A>.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 24 Feb 2017 07:41:13 GMT https://community.qlik.com/t5/QlikView/Qlikview-Macro-to-Save-as-Binary-Excel-Format/m-p/1259062#M397451 marcus_sommer 2017-02-24T07:41:13Z