Journal Upload Cant Find Project or Library

When using MS Excel document or MS Access that digest functions or buttons which need VBA (Visual Basic Applications) for the Macros to perform some assigned job, the user may get a compilation fault "Can't find project or library."

What is the crusade of this Error?

1. This fault is usually acquired by the user'south MS Access or MS Excel program. The reason is that the program has a reference to an object or type of library which is missing and hence not constitute by the program. Appropriately, the program cannot use VB or Micro based functions or buttons. Therefore an error message is sent.

2. Sometimes a library may exist toggled or toggled off, causing a missing link betwixt the library and program lawmaking. So the compilation error is issued.

three. Since there are standard libraries, so missing a library sounds a bit of the least hazard. The other possible reason, in that case, is that library miss-match is the crusade of the mistake. For example, the user may accept a library (sabbatum Outlook) version of 2007, but the code'south reference may be looking for the 2010 version of that specific library. And then the program fails to find the corresponding library, thus issuing this compilation error.

4. Another scenario for the aforementioned error bulletin concerns the employ of Microsoft XP, which includes a reference to web service in the VBA project. When you run this project in MS Office 2003, the same compilation error appears. The reason is the same, i.east., an object or blazon of library is missing (or non found).

Solution1. Calculation or Removing a Reference to a Library

The first solution to fix the "Can't Find Project or Library" error in MS Access is to remove a library reference. To practice and so, you lot tin can follow this step-past-step process.

Step 1: Launch MS Access on your PC and open the Database/Application that's showing the fault.

Stride 2: Now, simultaneously printing "Alt" + "F11" to launch the VBA editor window.

Pace three: Now, click the "Tools" button at the top menu bar and select "Preferences" from the drop-downwards menu.

Pace 4: In the next dialog box, uncheck the "Missing: Microsoft Access Object" and click "Ok" to save your changes.

Restart MS Admission and check if you encounter the same error anymore or not.

Solution2: Registering a Library File

There are many situations when installing new software automatically de-registers a few specific libraries. In such cases, many MS Admission functions will not work and you'll exist prompted with the "Can't Notice Project or library" error. A quick and easy way to fix this effect is to only annals a library file manually.
Although it's a bit complicated to manually register a library file, you can follow these steps to go the job washed.

Step 1: Right-click the "Showtime" button and click "Command Prompt (Admin)" to launch the command prompt every bit an administrator.

Footstep two: In one case y'all're in the CMD window, simply blazon REGSVR32 "Path of the DLL File that you want to register". For instance, REGSVR32 "C:\Program Files\Blackbaud\The Raisers Edge vii\DLL\RE7Outlook.dll".

This volition register the desired library file and you won't encounter the same error anymore.

Solution3: Try Un-Register Or Re-Register The Library

Finally, if cipher works, you can either re-register or unregister the library file completely to prepare the mistake. Get-go, let'south check out how to re-register a library file.

Stride i: Press "Windows" + "R" and type Regsvr32.exe.

Stride 2: Printing Enter and type the full path of the missing library file. For example, "regsvr32 "c:\plan files\mutual files\microsoft shared\dao\dao360.dll".
If this doesn't set up the mistake, you can simply unregister the library file, To do this, supercede "Regsvr32.exe" with "regsvr32 -u" and once again paste the path of the library.

That's it; united nations-registering the library file will ready the "can't find project or library" error and you'll be able to work on your MS Access database without any interruption.

Video Tutorial to Ready Can't Find Project or Library Error

You can explore more from Wondershare Video Community.

Solution 4: Repair MS Excel File with Excel Repair Tool

Third-party Excel file repair software is at that place to resolve all such matters chop-chop and accurately. 1 of the Best Excel file Repair software to repair damaged/ corrupt Excel files is described beneath.

This Wondershare Repairit - File Repair is available for single also every bit multiple systems. The file repairing tool supports 11/10/eight/Vista/7 versions of windows and supports ten.10~OS 10.15 for Mac. This permits the repair of corrupted Excel files ( . XLSX) and restores all the data from corrupt to original Excel file.

Step 1 Select a corrupt Excel file from bulldoze and add files.

Step 2 Choose one or all corrupt Excel files to start to repairing process.

Step 3 Preview the repaired Excel file.

Step 4 Select a preferred location to save the repaired Excel file.

In addition to Excel Repair Tool or Excel file repair software, a few tips may assistance quick fixes (to repair corrupted Excel files).

Instance 1. When an Excel file is open up, try whatsoever one of the following.

1. Endeavour on a different calculator.

2. Switch off Auto-save.

3. Plow off the file-sharing.

4. Practice not run Excel from a floppy.

five. Please save the file as a spider web page and reopen it equally an Excel file.

Case 2. When Excel cannot open the file, endeavor one of the following.

ane. Open the corrupt file on the hard drive. Copy from floppy.

2. Find .xlb file. Also, keep a backup. Delete .xlb. Restart Excel.

3. Open file in MS Word or Notepad. That will let yous recover information just not formatting.

four. With MS Excel 97/2000 viewer, you can view the data and print it. Open the file using this gratis program to recover information. This program will recover formatting as well as cell values.

5. Use Excel XP. This has meliorate options for recovery.

tibbstheence55.blogspot.com

Source: https://repairit.wondershare.com/office-document-repair/how-to-repair-excel-file-cant-find-project-or-library-error.html

Bagikan Artikel ini