Reference Object and References Collection

A Reference is a link from your VBProject to an external file, which may be an object library (for example, linking to the Word object library), a control (for example, Windows Common Controls), an ActiveX DLL, or another VBProject. By creating a reference to the external object, you can implement early binding, meaning that the referenced objects run in the same memory area, all the links are evaluated at compile time, and Excel provides ToolTip programming help when working with the referenced objects.

When you run your application on another machine, it may not have all the objects that your application requires. The Reference object and References collection provide access to these references, allowing you to check that they are all present and working before you try to use them.

The tables that follow define the Collection and VBE properties.

0 0

Post a comment