topic Excel XLSB Macro in QlikView https://community.qlik.com/t5/QlikView/Excel-XLSB-Macro/m-p/1305657#M406443 <HTML><HEAD></HEAD><BODY><P>Good Day,</P><P></P><P>I just want to find out, I have managed to write a macro that export my object to XLS, but it is 50mb in size, is there a way to use a macro to save the file in XLSB format?</P><P></P><P>Thank You</P></BODY></HTML> Sun, 21 May 2017 07:51:20 GMT goro2010 2017-05-21T07:51:20Z Excel XLSB Macro https://community.qlik.com/t5/QlikView/Excel-XLSB-Macro/m-p/1305657#M406443 <HTML><HEAD></HEAD><BODY><P>Good Day,</P><P></P><P>I just want to find out, I have managed to write a macro that export my object to XLS, but it is 50mb in size, is there a way to use a macro to save the file in XLSB format?</P><P></P><P>Thank You</P></BODY></HTML> Sun, 21 May 2017 07:51:20 GMT https://community.qlik.com/t5/QlikView/Excel-XLSB-Macro/m-p/1305657#M406443 goro2010 2017-05-21T07:51:20Z Re: Excel XLSB Macro https://community.qlik.com/t5/QlikView/Excel-XLSB-Macro/m-p/1305658#M406444 <HTML><HEAD></HEAD><BODY><P>Hi Jan,</P><P></P><P>Something like this</P><P></P><P><STRONG>XLApp.SaveAs "C:\Temp\Test.xlsb" , 50</STRONG></P></BODY></HTML> Sun, 21 May 2017 08:04:33 GMT https://community.qlik.com/t5/QlikView/Excel-XLSB-Macro/m-p/1305658#M406444 tamilarasu 2017-05-21T08:04:33Z Re: Excel XLSB Macro https://community.qlik.com/t5/QlikView/Excel-XLSB-Macro/m-p/1305659#M406445 <HTML><HEAD></HEAD><BODY><P>Tamil,</P><P></P><P>Spot on!!</P><P></P><P>Thank You!!!</P></BODY></HTML> Mon, 22 May 2017 04:49:33 GMT https://community.qlik.com/t5/QlikView/Excel-XLSB-Macro/m-p/1305659#M406445 goro2010 2017-05-22T04:49:33Z Re: Excel XLSB Macro https://community.qlik.com/t5/QlikView/Excel-XLSB-Macro/m-p/1305660#M406446 <HTML><HEAD></HEAD><BODY><P>No problem Jan. This might be helpful to you (or someone) </P><P></P><UL><LI><SPAN style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;"><CODE style="padding: 1px 5px; font-style: inherit; font-weight: inherit; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; background-color: #eff0f1;">50</CODE> = <CODE style="padding: 1px 5px; font-style: inherit; font-weight: inherit; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; background-color: #eff0f1;">xlExcel12</CODE> (Excel Binary Workbook in 2007-2013 with or without macro's, xlsb)</SPAN></LI><LI><SPAN style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;"><CODE style="padding: 1px 5px; font-style: inherit; font-weight: inherit; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; background-color: #eff0f1;">51</CODE> = <CODE style="padding: 1px 5px; font-style: inherit; font-weight: inherit; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; background-color: #eff0f1;">xlOpenXMLWorkbook</CODE> (without macro's in 2007-2013, xlsx)</SPAN></LI><LI><SPAN style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;"><CODE style="padding: 1px 5px; font-style: inherit; font-weight: inherit; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; background-color: #eff0f1;">52</CODE> = <CODE style="padding: 1px 5px; font-style: inherit; font-weight: inherit; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; background-color: #eff0f1;">xlOpenXMLWorkbookMacroEnabled</CODE> (with or without macro's in 2007-2013, xlsm)</SPAN></LI><LI><SPAN style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit;"><CODE style="padding: 1px 5px; font-style: inherit; font-weight: inherit; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; background-color: #eff0f1;">56</CODE> = <CODE style="padding: 1px 5px; font-style: inherit; font-weight: inherit; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; background-color: #eff0f1;">xlExcel8</CODE> (97-2003 format in Excel 2007-2013, xls)</SPAN></LI></UL><P></P><P>Have a nice week ahead!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 22 May 2017 07:43:08 GMT https://community.qlik.com/t5/QlikView/Excel-XLSB-Macro/m-p/1305660#M406446 tamilarasu 2017-05-22T07:43:08Z Re: Excel XLSB Macro https://community.qlik.com/t5/QlikView/Excel-XLSB-Macro/m-p/1305661#M406447 <HTML><HEAD></HEAD><BODY><P>Brilliant!!!!!</P><P></P><P>I have saved this!</P><P></P><P>A gold mine has been found <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 22 May 2017 07:52:16 GMT https://community.qlik.com/t5/QlikView/Excel-XLSB-Macro/m-p/1305661#M406447 goro2010 2017-05-22T07:52:16Z