Microsoft KB Archive/124277

{|
 * width="100%"|

XL5 Err Msg: "Can't Find Project or Library" Running Macro

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 5.0, 5.0c
 * Microsoft Excel for the Macintosh, versions 5.0, 5.0a
 * Microsoft Excel for Windows NT, version 5.0
 * Microsoft Excel for Windows, version 7.0

-

SUMMARY
In Microsoft Excel 5.0, you may receive the following error message when you attempt to run a Visual Basic macro:

Can't Find Project or Library

RESOLUTION
To correct the referencing problem, follow these steps:


 * 1) In the References dialog box, click Browse.
 * 2) Select the correct path and name of the file you want to reference and click OK.

The new file name, with the correct path shown at the bottom, should appear in the References dialog box.
 * 1) Click OK and save the file.

You should be able to run the macro once the references have been set to the correct files.

MORE INFORMATION
In Microsoft Excel version 5.0, in order to use external or custom functions from another library or workbook, you must establish a reference to the file through the References option on the Tools menu. The References option allows you to add, delete, or make available for editing Visual Basic references to libraries or other workbooks that are specified for the active workbook. You must be in a Visual Basic module to use this command.

If you try to run a Visual Basic macro that has a reference to a file or library, and the file or library does not exist in the specified location, you will receive the error message above. To check the location of any references your workbook may have, follow the steps below:


 * 1) On the Tools menu, click References.
 * 2) Select any reference listed in the Available References list.

The path to the file will be displayed in the Group box at the bottom of the References dialog box.