Excel XLSB Macro

[goro2010]

Good Day,

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?

Thank You

[tamilarasu · Accepted solution]

Hi Jan,

Something like this

XLApp.SaveAs "C:\Temp\Test.xlsb" , 50

[goro2010]

Tamil,

Spot on!!

Thank You!!!

[tamilarasu]

No problem Jan. This might be helpful to you (or someone)

• 50 = xlExcel12 (Excel Binary Workbook in 2007-2013 with or without macro's, xlsb)
• 51 = xlOpenXMLWorkbook (without macro's in 2007-2013, xlsx)
• 52 = xlOpenXMLWorkbookMacroEnabled (with or without macro's in 2007-2013, xlsm)
• 56 = xlExcel8 (97-2003 format in Excel 2007-2013, xls)

Have a nice week ahead!!

[goro2010]

Brilliant!!!!!

I have saved this!

A gold mine has been found