Email:      Pass:    Pass?
Advertisements


Free Excel Forum

Cant Find Project Or Library Error When Running An Office 2003-file On Office 2010

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Hi,

My subject says it all basically. I have created a workbook at work using excel 2003 but when I try to work at it at home (in office 2010) i get the "Can't find project or library"-error. It seems that it's only my userforms that generate this error.

Any ideas to why?

Thank you all brilliant minds!

/Mike

Similar Excel Video Tutorials

Helpful Excel Macros

Delete a VBA Module From Excel
- Delete a VBA macro module from Excel with this macro. This macro allows you to fully remove a macro module from Excel.
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
- This free Excel macro illustrates all of the possible parameters and arguments that you can include in the PrintOut Meth
Display the Print Window in Excel
- This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear when
Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
- Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in the
Name Worksheets Based on Cell Contents
- This macro allows you to have your worksheets named by whatever is in a particular cell within a worksheet. This means

Similar Topics









I have just upgraded to Office 2010 and suddenly one of the .xla files that I use will not load and gives the error "Can't find project or library". I have seen mentions on the web of checking Tools->References but References is greyed out. Any ideas/



We have a macro that exports the data from Project 2010 to an excel file. It works well when we use it on a Windows 7 or a Windows 8 machine, but with Office 2010 installed. But now when I am testing it on a Windows 8 Machine with Project 2010 standard but Office 2013, I am getting a Compile error of Cant find the project or Library.

The macro references Microsoft Excel 14.0 Object Library (under VBA menu - Tools - References ) on the machines that it works fine. But on the Windows 8/Office 2013 machine it references to Microsoft 15.0 Object Library. Is this what is causing the error?

Can someone please help me how to figure this error out? How do change the reference or fix the reference?
Thanks

Hi, we recently upgraded from office 2003 to office 2007. In excel, I have a few macros that are now saying "Compile Error: Can't find project or library".

The lines of code that are highlighted include
Environ("username")
Lcase()
Format()


How do I resolve this? I find it hard to believe that these common elements would not be included as a standard part of Office.


Hi,
can anyone here adivse me on what to do. I have now finished my project and
it works exactly as i want it too. However, i have come across this very
large problem.
Introducing the book onto our server where everyone else uses excel 2000. I
created this book on excel 2003. So when someone else issues a macro they
immediately get an error saying Object not found.
i went into the Visual Basic Editor / References and looked for the office
library but it says:
MISSING.Office 11 object library.
Is there a way around this or have i just wasted my time on this book? Can i
copy over the office 11 object library, or save this book as an earlier
edition?
or, do i have to upgrade everyone to office 2003?

please advise.

Very Frustrated Nige



I have an Excel 2007 spreadsheet that works perfectly but will not work with Excel 2010. One of the lines of code that is now failing is -

ResultsWindow.PostTax.Value = Format(0, "$* #,##0")

All this is trying to do is to format a number in a field on a Userform but I get the message "Compile Error: Can't find the Project or Library". From what I have been able to find on the internet, this is a problem with MS SOAP v3 not being compatible with 64 bit systems. In the program references, Microsoft Office SOAP type library v3.0 is shown as missing.
Does anyone have a simple fix for this type of problem. Thanks.




Hi,

I'm working on an automation that will connect ms excel and outlook.

A flexible code has to be written to work on both office 2007 & 2010 versions.

I'm getting a compile error "Can't find project or library" when i used a code taken from the below thread.

http://www.excelforum.com/excel-prog...ml#post3453679

I've given the code below which i used. Kindly help to overcome this issue as this an urgent assignment to be completed.



Please Login or Register  to view this content.



Does anyone have a VBA function that reads which version of Excel a user is running, compares it to the version of Excel that last saved the worksheet being opened, then ensures the library pointers are correct for the user's version of Excel?

I need to run something like this on "worksheet open" to avoid compile errors users are encountering as a result of a shared worksheet file being edited and saved under two different versions of Excel as the worksheet file is passed from user to user to gather the needed inputs to the application.

Background:
I'm a home grown Excel "programmer" that has inherited an excel VBA worksheet application that is collaboratively shared amoung several users to complete data entry. The app was originally developed and maintained with Excel 2002. The user group have either MS Office 2002 (XP) or MS Office 2003 installed. I myself have MS Office 2003. We are all running on Windows XP. It seems when a file has been saved by a user running Excel 2003 the library pointers or the version of Excel that save the file are saved with the worksheet. Subsequent users running Excel 2002 run into a VBA compile error due to a missing pointer to the MS library containing the regedit.dll when opening the file that has prreviously been saved by a user who modified it while running Excel 2003. Sometimes this can be solved by walking the Excel 2002 user through clearing the error, resetting the VBA debugger, and using the object browser in the VBA editor to find and add the correct VBA library for MS Office 2002 to the object list. This process also fails on occasion (see one of my other posts). I've tried to get all users upgraded to MS Office 2003, but some are unable to due to local restrictions.


I'm a novice with VBA in Excel and I'm not sure how Object Libraries work. I have a workbook in MS Excel 2010. I have code written that will take one of the single sheets in the workbook and create a new mail message in Outlook with the sheet attached and ready for the user to enter an email address for sending. I discovered that to make this work, I had to reference the Microsoft Outlook 14.0 Object Library in the workbook. This code works perfect in MS Excel 2010. My problem is that some of my users run MS Office 2007. When they fire the code to send the email, they get a bug (Library not found). I can fix this by having them reference the Microsoft Office 12.0 Object Library that comes with MS Excel 2007 and it will work fine. I update this workbook and redistribute to my users all the time and evertime they update, they get the "Object not found" error because the version I send them doesn't have the proper 12.0 Object Library referenced. How can I redistribute my workbook WITH 12.0 Object Library referenced so that they don't have to go to VB and update the reference?


I am trying to do a simple file search. My code (snippet) is something like this:

With Application.FileDialog(msoFileDialogFolderPicker)
.Show
fLdr = .SelectedItems(1)
End With

This works on my home version (uSoft Excel 2003 with the Microsoft Office 12 Office Library).

My problem is that I am porting the code to an Excel 2000 version, which only has Microsoft Office 9.0 Object Library, and I get a runtime error (Object doesn't support this property or method).

2 questions.

1 - Is there some other library in Excel 2000 that can do the same thing?
2 - Can I somehow bring in a Microsoft Office 12 library to my Excel 2000 by some means?

Thanks!!!


Basically, the macro I created for my worksheet works fine on my computer. However, when I posted this file to our internal system so that other coworkers could use the file. They got this "can't find project or library" error. The excel file works fine on computers in my department, but it only works for some people who work outside of my unit.

I looked this error up on the web and found that it is a fairly common error. So, I tried to solve the problem by comparing the References that my other coworkers had to the References that I had on my computer. It turns out that they get the same errors even though we both have the same References (OLE Automation, Microsoft Office 11.0 Library..) .

I want to stress that I have not unchecked any libraries because I'm assuming that since we have the same references, then unchecking those libraries will make no difference.

Is there any way to solve this problem? Please let me know. Thanks.


Hi all,

I've had a file that has been in use for many months without a problem but now all of a sudden I get a "Can't Find Project or Library" compile error in a userform.

The line that is triggering this is Ucase(application.username).

Has anyone of you expreienced something similar? I've searched everywhere for a reasonable explanation . I may have opened and watched the code from within Excel 2010. Could this have something to do with it?

BR
Percy




Hi..

this is my first post in this forum.. so please bear with my language..
I am running Windows 8 Pro (64bit) and Office 2010 SP1 (32bit) (both patched up to date) and have a Office 365 P1 subscription.

When I create a document from a SharePoint online document library,
the document opens the correct local app, i.e. Word 2010, allows me to edit,
but when I come to save the document back into SharePoint online, Word displays the following error:

Upload Failed. Your changes were saved but could not be uploaded because of an error. You may be able to upload this file using the server Web page.

It allows me to save the document locally and use SharePoint upload to manually upload the document, however this is not the method I am trying to use that should otherwise work from the client app.

I work with SharePoint in my professional career and I know that documents created in SharePoint should able to be saved directly back to the document library from where they were created from.

The Upload Center also displays an error for the document I have attempted to upload but simply states Upload Failed.

I have cleared the Document Cache, rerun the Desktop setup and reinstalled Office 2010 without success. The only thing I have not tried is using Windows 7, Office 2010 and Office 365.

Has anyone identified an answer to this issue?

Thanks,
Reba

I just built a new tower system to replace my older laptop (it's a real screamer BTW, so if anyone wants specs just PM me).

I'm now Running 64-Bit Windows & Office 2010, as well as 32-Bit Vista & Office 2003 in a VMWare Virtual Machine to support older apps.

I was working on a 2003 db in the Virtual Machine and shut it down (for some odd reason VMWare needs to be shut down every few hours or it just gets progressively slower), then opened it in 2010 to check something. When I reopened it in 2003 I got a "VBA Project Corrupted" error message that required a hard shut down to exit. I then got the same error in 2010.

I know that the 64-Bit versions require some additional VBA security protocols/checks, but has anyone else experienced the corruption error?

Fortunately I had a backup and lost very little work, but it's still a PITA, so if there's a way to program in a prevention I'm all over it.

Thanks,




I have a workbook that contains macros that allow export of data in Word Format. However the workbook was designed using Office 2010 and when tried with Office 2002 missing Reference to "Office 14 Word Object Library" is noted.

All other References though migrate ok.

I have added code to remove all References by GUID reference numbers on exit and reintroduce them on load. This works together with some late binding for some features not supported between 2010 to 2002.

I would rather not do this as I want to give the workbook to others to use and this requires "Trust access to VBA project object model" to be set.

This is my first post, so I hope explanation is clear.

Hello,

Last time i did some excel vba using excel 2003, but after changing to 2007, my program can't work. The error says like this : Compile Error: Can't find project or library.
How could I solve this?
I've upload the file for reference

Thanks in advance!!!




Hello- I'm banging my head against the wall on this one. Searched this site, but can't find a solution.

When I try to open an .xls file in office 2010, I get the following error: 'file is in a different file format than its extension indicates'. It then opens in protected mode.

What is wrong. The file opens fine in 2003, but when I try to open in 2010, I get that error.

Any advice?

Thanks!

Setup: Office 2003 and 2010 - All versions are up to date and running in Win 7.



Hello all,

I really need to make this work, so hopefully someone can help me. I wrote the macro VBA code in Excel 2010 and its all working, however, when i transfer the file to Excel 2007 or older, it gives me a Compile error: cant find project or library and highlights (Format() function).

I read stuff in internet that there needs to be adjustments made at the other PC's, however i do not have access to them. Is it possible to maybe decrease the complexity or declare values differently so that it would work on the older software?

I am attaching the workbook here. If i missed out some information or you have any questions, please ask!

Hi,

I am working with an Excel file which needs to be used on Vista/Excel'07 as well as XP/Excel'03 machines. If the file is saved on a Vista machine, when opening the same file on an XP, the following error occurs:

Compile Error:
Can't find project or library

And it highlights "Dim xxx as CommandBar". I also noticed dictionaries and a bunch of other things do not work. In the Vista machine, MS Office 12.0 Object Library is used, while the XP has MS Office 11.0 Object Library. I have tried loading the missing libraries (either machine) but when I go to browse, and select the MSO.dll file, nothing happens. I search the list but it's not there. I'm not sure if this is even the solution.

Also of note:
-If the file stays on XP machines, it's fine. Or if it stays on Vista machines. It's only when coming back from Vista to XP; it can't compile.
-I think it may also be something relating to this particular file, because I have a very similar file which has no problems going back and forth.

Thoughts?


Hi,

I am working with an Excel file which needs to be used on Vista/Excel'07 as well as XP/Excel'03 machines. If the file is saved on a Vista machine, when opening the same file on an XP, the following error occurs:

Compile Error:
Can't find project or library

And it highlights "Dim xxx as CommandBar". I also noticed dictionaries and a bunch of other things do not work. In the Vista machine, MS Office 12.0 Object Library is used, while the XP has MS Office 11.0 Object Library. I have tried loading the missing libraries (either machine) but when I go to browse, and select the MSO.dll file, nothing happens. I search the list but it's not there. I'm not sure if this is even the solution.

Also of note:
-If the file stays on XP machines, it's fine. Or if it stays on Vista machines. It's only when coming back from Vista to XP; it can't compile.
-I think it may also be something relating to this particular file, because I have a very similar file which has no problems going back and forth.

Thoughts?


Hello

I run an xla file, created in office 2003 in office 2007.


in 2003 - I created a toolbar, and was able to display its icons automatically on the screen via vba.

in 2007 - the toolbar is located inside the Add-Ins tab - so I need to click on the Add-Ins Tab to display my icons.

My question is how can I "auto open" the Add-Ins Tab in my vba code and "lock it" - so that all other tabs - "Home Insert PageLayout Formulas" etc. will be invisible or at least disabled.

Another issue is upgrade to Office 2010. Will my xla work in 2010 as it works in 2007 ? Are there many differences between them ?

thanks !!!

Hello everybody,

Is it possible to show a message box when a workbook is opnened in version 2010?
I would like to give users some instructions for an error that occurs when opening in 2010.

Some features I used aren't recognized in 2010 and gives the error:
"Compile Error: Can't find project or library"

This can be solved by following these instructions:
1. Open the database or application.
2. Open a module in Design view or press ALT+F11 to switch to the Visual Basic Editor.
3. On the Tools menu, click References.
4. Clear the check box for the type library or object library marked as "Missing:"

Even better still would be if these steps can be done utomatically




Hello Experts

I am back again with some problem that is recently i formatted my system and reload the Windows 8 with Office 2007

now my problem is when i run the code then i am getting the one error msg that is

Compile error

Can't find the project or Library



Please Login or Register  to view this content.


When i press the Ok button then it is select to the line is

uRows =

kindly suggest me with the above problem and suggest me how to check the missing Objects or Library in excel file

Thanking You in advance

SP



I'm in a client office where the version of Office is 2010. At home I only have Office 2003 so I often save spreadsheets in 2003 format (.xls instead of .xlsx) so I can use them at home. When I do this it takes up to 10 seconds to save the file even if there are only a few cells occupied. Previously I've used computers with Office 2007 and found Excel 2007 would save in Excel 2003 format almost instantly.

Is there something wrong in my Office 2010 set up? If so, what I can do to Excel 2010 to make it save faster in the 2003 format?

Could it be that Microsoft has put this slow feature in deliberately to encourage all users of Office 2003 to upgrade, or am I just being paranoid?

Our office just upgraded from Office 2003 to Office 2007. I have been working with great determination on a project that relies heavily on VBA code and macros etc. Everything was written and references 2003 files (.xls).

My home computer, for which I do most of my project development still uses Excel 2003.

My project will not work on my employers system because old .xls files are not easily recognized. Any reference to an xls file in my code results in an error.

What can I do to ensure cross platforming works between both systems? Will it require a whole lot of coding changes. What I change to function in 2007, will create errors in 2003, and vice versa.

Jenn




I have an excel file where I copy ranges to a word document. I was initially writing this in excel 2003, but they've upgraded my machine to office 2010.

I didn't know it, but the word reference got updated to microsoft word 14 instead of 11. So I got the can't find project or lib error when running it again in 2003. I've tried to ensure this works in 03/10 as we have mixed machines.

It was easily fixed by unchecking the 14 ref and renabling 11 but is there a way in code or something to prevent this from happening? I don't think you can enable a reference via vba so maybe there's no way around it, but wanted to see if there's a solution I'm not aware of.

OK I found this:

http://www.ozgrid.com/forum/showthread.php?t=56538

so I think it may be possible but it's not working out:

I tried:



Please Login or Register  to view this content.


but getting the error: user-defined type not defined. Then I read to enable trust accsess to visual basic project in macro --> security but same thing.

Then I read enable ms visual basic for extensibility but that didn't work.

Is there some other means of doing this?