Cant Find Project Or Library Error When Running An Office 2003-file On Office 2010
|
|
Search Excel Forum Posts, Tutorials, Macros, Tips, and More
Cant Find Project Or Library Error When Running An Office 2003-file On Office 2010 - Excel
|
View Answers
|
|
|
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.
Similar Topics
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.
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,
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'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?
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 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!!!
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
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.
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,
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,
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 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 !!!
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?
I have a program which was developed in Excel 2003. It has always worked fine on my web book using Excel 2007. All of a sudden, whenever I try to enter data anywhere in the file I get an error screen which says "Can't find Project or Library". I tried replacing the file thinking it night be corrupt, but I keep getting the same error message. I clicked on the help screen but I'm not sufficiently experienced with computers to even understand what help is talking about. Anyone have any suggestions?
Hi,
One of my WB behaves very strange lately.
Upon opening, it presents a lot of "Compile Error: can't find Project or Library".
Hereunder is on of the UDFs I have in this WB and the compiler marks this TheDate = as the cause for the error.
I cannot click 'References...' (to check for: Missing) because it is grayed-out.
I didn't use any Option Explicit command and that file works fine when opened in Excel 2003 (in which it was originally created).
Any Ideas ?
Thanks, Elm
Code:
Function Quarter(CheckDate As Date)
TheDate = CheckDate
Quarter = DatePart("q", CheckDate)
End Function
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 add-in I used in several earlier versions of excel. It is named
!options.xla.
During previous upgrades, I copied the file to the directory containing add-ins--here on my current system:
"C:\Program Files (x86)\Microsoft Office\Office12\Library\!OPTIONS.XLA"
then "enabled" the add-in from the excel menus.
With excel 2007, I get an error message:
"opening the VBA project in this file requires a component that is not currently installed. This file will be opened without the VBA project. For more information, search Microsoft office online for vba converters."
then:
This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.
After I have installed the add-in, I get these error messages on excel startup. When I have unistalled the add-in, I get these messages upon openeing a spreadsheet that tries to use the add-in.
I have searched Microsoft extensively. The only vba converter I have located there is to convert excel 2007 vba to be usable by earlier versions.
Can I make my add-in work for 2007?
I have a spreadsheet with a set of macros. One of the macros used the Microsoft Calendar Control 11 to furnish a popup calendar. However, I have disable this by erasing the page code which referenced the control.
I have given a copy of the spreadsheet to a coworker. Everything worked fine until she got Office 2010, at which point the macros quit working with the error message "Unable to find project or library." Using the VBA References dialog box, I have traced this issue to the fact that the Office 2010 installation on her computer does not have the Calendar Control 11 file. I went into the References dialog & tried to uncheck Microsoft Calendar Control 11, but I get an error message telling me it can't be deleted because it's in use. I've looked through my other macros & can find no references to it. The help box on the error message says to remove the control from the form & then uncheck the box. There are no forms listed in the project window.
Can someone tell me how to find where this may be so I can delete it? While we could just install the control file on her computer, I'd really prefer to clean up the spreadsheet so I don't keep running into this every time I provide a copy to someone.
Any help appreciated.
---GJ Case
I am writing Excel automation using Visual basic 6.
The application is supposed to read the excel file created by the
Office 2003 version. I also have Office 2003 on my machine so I set my
reference to "Microsoft Excel 11.0 Object Library"
Now when I try to run the program on the computer that doesn't have
Office 2003 but has Office 2000, it crashed.
Can you let me know how to handle this problem.
I do have the error handling section to display the error but it seems
that the program try to execute but got Error "An exception "Unhandled
Win 32 Exception" has occured in Program.exe"
I would like to check if the excel on the machine is not version 2003
and just abort the program without crashing.
Can anyone help with the sample of source code to determine the version
of Excel in the computer?
Thanks,
Deen
Hello everybody,
I formatted my notebook because it had problems.
Before I had Win2000 and Office 2000, now I have Win XP and Office 2003.
The problem is that I have various projects in which I used following VB 6
code to open dinamically Excel and write in.
"..
'I try open excel
Set XlsApp = GetObject(, "Excel.Application") 'look for a running copy
of Excel
If Err.Number <> 0 Then 'If Excel is not running then
Set XlsApp = CreateObject("Excel.Application") 'run it
End If
Err.Clear ' Clear Err object in case error occurred.
On Error GoTo Error_Excel_Mng
...."
I have seen that recompiling (make Exe) and releasing the software on
customer's pc having Win 2000 and especially Office 2000 my program no more
work correctly.
I think because the vb reference is 'Microsoft Excel 11.0 Object Library'.
Our helpline says that I can't install Office 2000 after Office 2003.
I ask you which is the better solution that I can use.
I prefer not to return to have my laptop with previous versions vecchie or
to need another old pc.
Thank you very much.
Andy
Hi friends,
I am getting the following error each time when i close the workbook or I use the addin.
"object library invalid or contains references to object definitions that could not be found".
I have used the same addin many times. Yesterday I upgraded Microsoft Office to 2007 and since then I am getting this error. I have again installed Microsoft office 2003 but still i am not getting rid of the error.
In VBA --> Tool --> Reference there are no references that are missing..
Please help.
Regards,
Vaibhav
I had created an accounting calendar that worked in Excel 2010 but had to uninstall the 'click to run' version as it caused problems with other software I run.
On re-installing Excel 2010 the full version I now have a 'Compile Error: can't find project or library' which would appear to be an issue with mscal.ocx
I understand this has something to do with the calendar not being registered and I have no idea how to go about correcting it so any happy would be greatly appreciated.
I have attached the spreadsheet which has the problem when on the data page and screen shots of the error message that appears.
I have inhereted an Excel template from someone at my office. I am trying to update it, but sometimes when I change cells, I get an error message saying "Cannot Find Object or Library" and then it opens some box that says "References-VBA project and then all these checkboxes below. Does anyone know what this means?
We have an Excel file with Macros that will open on some machines, but not others. I get an error message "Can't find project or Library" and the VB editor will display:
Sub Auto Open
INIT
END SUB
Any suggestions as to how I can get this file to work on all machines?
A little insight: We have this file on an network share. We are using Office 2003 professional suite. The file originator is from an outside source, however, as I mentioned, it will open and work fine on some machines. Office has been removed and reinstalled, SP3 has been installed. Not too sure what else we can do.
