J John Apr 25, 2008 #1 Is there any benifit to using binary format for your workbooks? does it support macros? work fine with addins?
Is there any benifit to using binary format for your workbooks? does it support macros? work fine with addins?
D Dave Peterson Apr 26, 2008 #3 I'm guessing that the OP is using xl2007 and wants to know about .xlsb (or ..xls)? http://www.microsoft.com/interop/docs/officebinaryformats.mspx or http://office.microsoft.com/en-us/help/HA100069351033.aspx From what I've read, the .xlsb binary files open a little faster (less for excel to do???). And yep, they can contain macros. I still use personal.xla in xl2007. I haven't resaved it as .xlab (yet).
I'm guessing that the OP is using xl2007 and wants to know about .xlsb (or ..xls)? http://www.microsoft.com/interop/docs/officebinaryformats.mspx or http://office.microsoft.com/en-us/help/HA100069351033.aspx From what I've read, the .xlsb binary files open a little faster (less for excel to do???). And yep, they can contain macros. I still use personal.xla in xl2007. I haven't resaved it as .xlab (yet).