The XLB File


Excel stores customized toolbar and menu bar configurations in an XLB file. Even though Excel 2007 doesn't officially support custom toolbars and menus in the way that it did in previous versions, it still uses an XLB file.

When you exit Excel, the current toolbar configuration is saved in a file named Excel12. xlb . This file is (most likely) located here:

 C:\Documents and Settings\  <username>  \Application Data\Microsoft\Excel 

This binary file contains information regarding the position and visibility of all custom toolbars and custom menu bars, plus modifications that you've made to built-in toolbars or menu bars.




Excel 2007 Power Programming with VBA
Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
ISBN: 0470044012
EAN: 2147483647
Year: 2007
Pages: 319

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net