Microsoft KB Archive/111494

From BetaArchive Wiki
Knowledge Base


PSS ID Number: 111494

Article Last Modified on 1/17/2001



The information in this article applies to:

  • Microsoft Visual Basic for Applications 1.0



This article was previously published under Q111494

SYMPTOMS

In a Microsoft Visual Basic Programming System, Applications Edition module, if you choose References from the Tools menu, multiple references with the same name are listed in the References dialog box.

CAUSE

The References dialog box provides access to methods and properties from other applications that support object linking and embedding (OLE). The Available References list includes object library files (*.OLB) and specific application files, such as Microsoft Excel Workbook files, Microsoft Excel Add-in files, and Microsoft Project Project files. These files are listed in the Available References list without the full path. Therefore, if two or more files are listed in the References dialog box with the same name from different directories, they appear in the References dialog box with the same name.

WORKAROUND

To determine the location of a file listed in the References dialog box, select the filename from the Available References list. The name of the directory path as well as the language in which the reference was written is listed under Group.

MORE INFORMATION

The References command, available on the Tools menu, adds, deletes, or makes available for editing Visual Basic references to object libraries and other files from applications that support object linking and embedding (OLE). Files that may be listed in the References dialog box include Microsoft Excel Workbook files, Microsoft Excel Add-in files, and Microsoft Project project files. You must be in a Visual Basic module to use this command.

To remove a reference from the Available References list, clear the check box next to the referenced file and choose OK. If the file is not loaded, the reference does not appear in the References dialog box the next time you choose References from the Tools menu.


Additional query words: addins add ins filename

Keywords: KB111494
Technology: kbVBA100 kbVBASearch kbZNotKeyword3 kbZNotKeyword6