Since version 7 the mechanism of ActiveX automation (which at the time was called object automation) has been used to incorporate various extensions into Excel. The extensions described in this section must be activated before use with ToolsReferences. Furthermore, an entire library of new objects, methods , and properties is available, which can be used as Excel keywords in VBA code.
Office Library To simplify and standardize the search for Office documents, when a document is saved, supplementary information is now saved with it. You can examine the possibilities available for searching for files from the dialog in FILEOPEN and for the input of supplementary information in FILEPROPERTIES. You can access the supplementary information in VBA code using the properties BuiltinDocumentProperties and CustomDocumentProperties .
Office Binder Library A further innovation in the Office suite of applications is that a group of Office documents (text, worksheets, databases, etc.) can be assembled as if enclosed in a binder. The files thus assembled can then be more easily managed. Binders are controlled using program code by means of the new objects Binder and Section .