VB Editor Object Model: Reference

A Reference object references either

• type library or
• another VBA project (that is set of modules).

Thus, adding references to VBA project extends the available functionality for the project with the functionality that is found in the TypeLib or the other project.

The type of a reference object is exposed in its .type property which is assigned one of the two following enumeration values

• vbext_rk_typeLib (= 0)
• vbext_rk_project (= 1)

A Reference object can be added using the References collection:

….references.addFromGUID(guid, major, minor)

guid refers to a GUID found in the registry under the key HKEY_CLASSES_ROOT\TypeLib.

With the GUI (Visual Basic Editor), a reference can be added with the menu Tools -> References…

The references collection