Additional Reference libraries - danielep71/VBA-PERFORMANCE GitHub Wiki

Home


Only add additional Reference Libraries when necessary.

1. Description

If you use objects in other applications as part of your Visual Basic application, you may want to establish a reference to the object libraries of those applications. Before you can do that, you should check if that the application provides an object library.

2. How to use

To see if an application provides an object library

  • From the Tools menu, choose References to display the References dialog box.
  • The References dialog box shows all object libraries registered with the operating system. Scroll through the list for the application whose object library you want to reference.
  • If the application isn’t listed, you can use the Browse button to search for object libraries (*.olb and .tlb) or executable files (.exe and *.dll on Windows). References whose check boxes are checked are used by your project; those that aren’t checked are not used, but can be added.

3. Performance Test

4. Results

5. Conclusions

Consider Late Binding instead of Early Binding as an alternative.

See https://support.microsoft.com/en-gb/kb/245115


Home