While working with a large Microsoft Excel dataset, sometimes we see that our VBA macros show an error named “can’t find project or library”. It occurs because of the user’s Microsoft Access or Microsoft Excel program. Today, in this article, we’ll learn three quick and suitable solutions to fix the error named can’t find project or library in Excel effectively with appropriate illustrations.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
3 Suitable Ways to Solve Can’t Find Project or Library Error in Excel
Every program has a reference to an object or the type of library. If the program can not identify the reference or type of library, hence, the program can not use in VBA Macros, then it shows an error named “can’t find project or library”.
Let’s assume we have an Excel worksheet that contains the information about several sales representatives of Armani Group. While using our worksheet in VBA Macros, then it shows an error named can’t find project or library because the program can not find the reference of that program or the type of library. Here’s an overview of the dataset for today’s task.
1. Use the Reference Command to Solve Can’t Find Project or Library Error in Excel
We can easily solve the error named can’t find project or library by using the Reference command. This is the easiest and the most time-saving way also. Let’s follow the instructions below to learn!
Steps :
- First of all, from your Developer tab, go to,
Developer → Visual Basic
- After clicking on the Visual Basic ribbon, a window named Microsoft Visual Basic for Applications – Can’t Find Project or Library will instantly appear in front of you. From that window, we will insert a Reference command from the Tools menu bar. To do that, go to,
Tools → Reference
- Hence, a dialog box named Reference – VBAProject pops up. From that dialog box, firstly, uncheck the Microsoft Office 16.0 Object Library option from the Available References drop-down box. Secondly, press the OK option.
- After pressing the OK option, go back to your active worksheet and you will be able to save the Excel file.
Read More: FIND Function Not Working in Excel (4 Reasons with Solutions)
2. Perform the Keyboard Shortcuts to Fix the Can’t Find Project or Library Error in Excel
Another easy way is to use the keyboard shortcuts to solve the error. Using the keyboard shortcuts, you will re-register or unregister the project or library file. Let’s follow the instructions below to learn!
Steps:
- First, press Windows + R buttons simultaneously to re-register a library file.
- Hence, a dialog box named Run will appear in front of you. From the dialog box, type exe in the Open box., and Press the OK button.
- Now, type the full path of the missing project or the library file. For example, regsvr32“c:\program files\common files\microsoft shared\dao\dao360.dll”.
- If that can not be able to solve the error, you can simply unregister the library file, To do that, replace “exe” with “regsvr32 -u” and again paste the path of the project or the library which is given in the below screenshot.
Read More: [Solved!] CTRL+F Not Working in Excel (5 Fixes)
Similar Readings
- Excel Find Last Column With Data (4 Quick Ways)
- Find Last Value in Column Greater than Zero in Excel (2 Easy Formulas)
- How to Find Lowest 3 Values in Excel (5 Easy Methods)
- Find External Links in Excel (6 Quick Methods)
- Excel Search for Text in Range (11 Quick Methods)
3. Register a Library File to Solve the Can’t Find Project or Library Error in Excel
In several cases, the Microsft Access or Microsoft Excel shows a “can’t find project or library” error. We can solve the error by using the Command Prompt to register a project or library file. Let’s follow the instructions below to learn!
Steps:
- First of all, If you are using the Windows 8 or later version, go to the search bar and type Command Prompt. Hence, press on the Run as administrator option. You can do that windows 7 or before from the start menu.
- After that, a command window named Administrator: Command Prompt will appear in front of you. From that command window, type REGSVR32 “C:\Program Files\Blackbaud\The Raisers Edge 7\DLL\RE7Outlook.dll”.
- Further, press ENTER on your keyboard, and you will be able to solve the error.
Things to Remember
👉 You can pop up Microsoft Visual Basic for Applications window by pressing Alt + F11 simultaneously.
👉 If a Developer tab is not visible in your ribbon, you can make it visible. To do that, go to,
File → Option → Customize Ribbon
Conclusion
I hope all of the suitable methods mentioned above to solve the Can’t Find Project Or Library Error will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.
Related Articles
- How to Use Excel Formula to Find Last Row Number with Data (2 Ways)
- How to Find First Value Greater Than in Excel (4 Ways)
- Excel Find Last Occurrence of Character in String (6 Methods)
- How to Find Last Row with a Specific Value in Excel (6 Methods)
- How to Find * Character Not as Wildcard in Excel (2 Methods)
- Excel Function: FIND vs SEARCH (A Comparative Analysis)