Identifying VBE Objects in Code

All the objects that form the VBE, and their properties and methods, are contained in their own object library. You need to create a reference to this library before you can use the objects; do this by switching to the VBE, selecting the menu item Tools O References, checking the Microsoft Visual Basic for Applications Extensibility 5.3 library, and clicking OK (see Figure 26-1).

References -VBAProject

Available References:

@ Visual Basic For Applications |a|

l*!l Microsoft Excel 12.0 Object Library BOLE Automation

@ Microsoft Office 12.0 Object Library gijcr^ft MgffiBaic for AncfcaijoBS ExtensibjKTjilj j. j IAS Helper COM Component 1.0 Type Library

□ IAS RADIUS Protocol 1.0 Type Library Ll A COM Addin to show a Date Picker Task Pane

□ A set of utilities for the Office 2000-200 3 VBE .1A set of utilities for the Office VBE

(JAAAA

□ Acrobat Access 2.0 Type Library Acrobat Access 3.0 Type Library ArrnTFHplnpr I.OTvnp I ihrflrv

Priority +1

Help

Microsoft Visual Basic for Applications Extensibility 5.3 -

Location: C: program Files \Common FilesV^licrosoft Shared \VB A \VB A6 WBE6EXT. OLB

Language: Standard

Figure 26-1

In code, this library is referred to as the VBIDE object library.

The full VBIDE object model is documented in Appendix B. The more important objects are summarized in the next sections.

0 0

Post a comment