References Collection Methods

Name

Returns

Description

AddFromFile

Reference

Method. Parameters: FileName As String. Adds a reference between the VBProject and a specific file. This should only be used to create references between workbooks.

AddFromGuid

Reference

Method. Parameters: Guid As String, Major As Long, Minor As Long. Adds a reference between the VBProject and a specific DLL, Typelib, and so forth. A library's filename, location, and version may change over time, but its Guid is guaranteed to be constant. Hence, when adding a reference to a DLL, Typelib, and so on, the Guid should be used. If you require a specific version of the DLL, you can request the major and minor version numbers.

Remove

Method. Parameters: Reference As Reference. Removes a reference from the VBProject.

The References collection provides two events, which you can use to detect when items are added to or removed from the collection. You could use this, for example, to create a Top 10 References dialog, by using Application events to detect when a workbook is opened or created and hooking into the References collection of the workbook's VBProject events to detect when a particular Reference is added to a project. You could maintain a list of these and display them in a dialog box, similar to the existing Tools O References dialog in the VBE (but without all the clutter).

Was this article helpful?

0 0
The Accidental Blogging Millionaires

The Accidental Blogging Millionaires

Get Inspired By The Most Popular Bloggers Online! If You Want To Skyrocket Your Success With Business And Improve Your Overall Life You Need To Have A Look At The Accidental Blogging Millionaires! Business can be a fight, particularly when you’re trying to establish one online and like all fights, to succeed you must find the winning techniques and apply them.

Get My Free Ebook


Post a comment