Compile Error Can't Find Project Or Library Excel Mac

Excel Visual Basic Compile Error Can't Find Project Or Library
Excel Can't Find Project Or Library

Apr 04, 2017 Dismiss Join GitHub today. GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.
You'll need to either find that type library or remove the programs' dependency on it. The UCase$ failure is due to that missing library. You should be able to locate the file on your Win2k machine so it can be.
Sep 28, 2012 Hi there, I am receiving the 'Compile Error: Can't find project or library' error- when I try to open Tools and References (which I have found in some of the other help topics) I can not click on References- Any can anyone help on what my issue is here?
Compile Error: Can’t find project or library. Font Encoders; VBA Macros; Compile Error: Can't find project or library Error: Can’t find project.

The French Microsoft Excel 5.0 object library was MS Excel FR 50 OLB. If you can't find a missing project or library on your system, contact the referencing project's author. If the missing library is a Microsoft application object library, you can obtain it as follows. Jan 09, 2017 If you are getting the Compile error can’t find project or library, then follow the solution given in the article to fix it easily.

Nov 26,2019 • Filed to: Recover & Repair Files • Proven solutions

When using MS Excel document or MS Access that assimilate functions or buttons which need VBA (Visual Basic Applications) for the Macros to perform some assigned task, the user may get a compilation error “Can’t find project or library”.

Part 1: What is the cause of this Error?

This error is usually caused by the user's 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 found by the program. Accordingly, the program cannot use VB or Micro based functions or buttons. Therefore an error message is sent.
Sometimes a library may be toggled on or toggled off causing a missing link between library and program code. So the compilation error is issued.
Since there are standard libraries so missing library sounds a bit of least chance. The other possible reason, in that case, is that library miss-match is the cause of error. For example, the user may have a library (sat Outlook) version of 2007 but the reference in the code may be looking for 2010 version of that specific library. So the program fails to find the corresponding library thus issuing this compilation error.
Another scenario for the same error message is concerning the use of Microsoft XP which include a reference to web service in VBA project. When you run this project in MS Office 2003, same compilation error appears. The reason is same i.e. object or type of library is missing (or not found).

Part 2: How to Repair Corrupt Excel File

For different situations some solutions to rectify the problem or to repair corrupted Excel file are always there. Like finding out the missing library or the cause of mismatch if it exists. The library is then added or alternatively the code may be rechecked to link to the appropriate library.

How can it be done?

Following the steps:

Step 1. Open the MS Excel file, giving an error message.

Step 2. Ensure that the sheet that has defined functions or buttons is selected.

Step 3. Press “ALT and F11 keys”, for VB Editor in a new window (as below).

Step 4. Click on Tools menu and then select References from pulled down menu, as shown

Step 5. Following dialog box will display ‘Missing object library or type’ is indicated, as shown below

Step 6. As in above display if check mark exists with missing library, uncheck it and click OK

Step 7. Exit and save the original Excel file.

Now check to ensure respective functions are working properly.

Part 3: Repair MS Excel File with Excel Repair Tool

Third-party Excel file repair software are there to resolve all such matters quickly and accurately. One of the Best Excel file Repair software, to repair and recover damaged/ corrupt Excel files is described below.

This Excel file repair software is available for single as well as multiple systems. The file repairing tool supports all versions of windows and supports Excel 2011 for Mac. This permits repair corrupted Excel file (.XLS and .XLSX), and restore all the data from corrupt to a new Excel file.

Recovers all kind of data stored in damaged excel file such as tables, charts, formulas, comments, images, etc.
Restore all of your corrupted excel files to their original standing.
Preview the repaired excel file in real-time,see how much of the file has been recovered as it is being repaired.
All kind of MS office corruption errors (for XLS and XLSX files only) can be handled with this tool.
This excel file repair tool can be used on both windows and Mac platforms in order to repair corrupt excel file.
All kind of MS office corruption errors (for XLS and XLSX files only) can be handled with this tool.
This excel file repair tool can repair damaged files of all versions from 2000 to 2016 that includes 2000, 2003, 2007, 2010, 2013, etc.

Step 1 Select corrupt Excel file from drive and search.

Step 2 Chooes one or all corrupt Excel file start to repairing process.

Step 3 Preview the repaired Excel file.

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

In addition to Excel Repair Tool or Excel file repair software, a few tips may be helpful for quick fixes (to recover or repair corrupted Excel file).

Case 1. When Excel file is open try any one of followings.

Try on a different computer
Switch off Auto-save.
Turn off the file sharing.
Do not run Excel from a floppy
Save the file as a web page and reopen it as Excel file.

Excel Visual Basic Compile Error Can't Find Project Or Library

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

Open the corrupt file on hard-drive. Copy from floppy.
Find .xlb file. Also keep a backup. Delete .xlb. Restart Excel.
Open file in MS word or Notepad. That will let you recover data but not formatting
With MS Excel 97/2000 viewer you can view the data and print. Open file using this free program to recover data. This program will recover formatting as well as cell values.
Use Excel XP. This has better options for recovery.

Recover & Repair Files

Recover Document Files
Repair Document Files
Recover & Repair More
Clear & Delete File

Sponsor

Excel Can't Find Project Or Library

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Comments

commented Apr 4, 2017

Using version 4.1.2, I keep getting the following error when I run my program on a Mac (I've tried two different systems, one 32 and one 64)

'Compile Error: Can't Find Project or Library'
The error is triggered by these lines (and possibly more, I didn't do an exhaustive review):

Public AsyncRequests as Dictionary
Private web_pConverters as Dictionary
Public function ParseUrlEncoded(Encoded as String) As Dictionary

Any idea what could be causing these errors?
Thank you so much for creating this program, it has saved countless hours at a small non-profit!

closed this Apr 4, 2017

commented Sep 30, 2017

@ethanlowens I see you closed this issue. Did you find a workaround? I'm running into a similar issue coming out of the WebHelpers classes, specifically in:

'
' 3. Url handling
' '

'
' Join Url with /
'
' @example
' VB.net ' Debug.Print WebHelpers.JoinUrl('a/', '/b') ' Debug.Print WebHelpers.JoinUrl('a', 'b') ' Debug.Print WebHelpers.JoinUrl('a/', 'b') ' Debug.Print WebHelpers.JoinUrl('a', '/b') ' -> a/b '
'
' @param {String} LeftSide
' @param {String} RightSide
' @return {String} Joined url
'
Public Function JoinUrl(LeftSide As String, RightSide As String) As String
If Left(RightSide, 1) = '/' Then
RightSide = Right(RightSide, Len(RightSide) - 1)
End If
If Right(LeftSide, 1) = '/' Then
LeftSide = Left(LeftSide, Len(LeftSide) - 1)
End If

End Function

commented Sep 30, 2017

FYI - when I looked at the references in the VBA editor there was a package was showing as 'MISSING' in the list. When I unchecked it, my code ran wihtout errors.