Excel VBA prompts "no project or database found" error Solution

Recently, I used Excel VBA to create a "supply, sales, and storage management system" for the purchasing department. As a result, the "Project or database cannot be found" error occurs on the computer of the purchasing department. Generally, this error occurs because the referenced project cannot be found or the referenced Object Library corresponding to the engineering language cannot be found. This error also occurs when you install the Office Lite version.

 

Solution:

1. Select the VBA project with an error in the VBE window. Shortcut: Alt + F11
2. In the main menu of VBA, choose tools> reference to open the reference dialog box.
3. Search for Missing items ..." , "Cannot find ..." , "Missing ..." And deselect the check box!
4. Generally, you can use step 1 to solve the problem. If the problem persists, find and select a reference similar to the missing entry in "available references" (except for the version number, if you have multiple versions with the same name, select the highest version.) If you still cannot solve the problem, it may be that the control or object library is missing on your computer. You need to download the control and register it, then return to the above steps to solve the problem!

 

Excel VBA cannot find project or library

 

 

Note: This article Reprinted from: http://www.pootor.com/excel-vba-excel-can-not-find-project-or-library/