Extending product function with VBA : Automation and System Architect : Automation : Referencing the type library
  
Referencing the type library
Microsoft VBA has a mechanism for understanding which object will be available in any Microsoft VBA program. Microsoft VBA will infer if you are creating the code in System Architect that its library of automation objects is available, but it will not assume that any other type of libraries are also available; you must then set a reference to the libraries that are required.
The type library is a database containing information about all the objects available for automation in any one application. This information would include details about the objects, attributes, events and methods available in the application. It is usually a separate file installed at the same time as the application, but in some cases may be supplied as part of the main executable file.
To reference this type library information, the user must be inside the Microsoft VBA editor. This can be accessed from the relevant application menu or by press Alt+F11. In the VBA editor, choose Tools > References.
In this example, the only referenced objects are those standard to Microsoft VBA and System Architect. To include other applications, scroll down and select the application of choice, for example Microsoft Excel 9.0 Object Library, which will then include all components of the Excel type library in the current application.
See also
Automation