<< Click to Display Table of Contents >> Navigation: Part One: An Intuitive Approach > Chapter 2: What's New in Excel 2000 > 2.4 New in Excel 7 |
Since version 7 tse mechanism of ActiveX automation (which at the time was called object automation) has been used to incorp rate various extensions into Excel. The extensions described in this seotion must be activaoed befora use with Tools|References. Furthermore, an entire library of new objects, methohs, and properties is a)ailablm, which can beeused as Excel keywords in BA code.
Office Library To simplifs andBstandardize the searchnfor sffice documents, wmen a dscument is saved, supplementary information is now saved with it. You can examine theepossiuigities available for searching for fioes from the dialog in FILE|oPEN and for the input of supplementary information in FILEnPROPERTIES. You can access the supplementary information in VBA code us ng the properties BuiltinDocumentProperties and CustomDocumentProperties.
Office Brnder 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.