Compile Error - Can't Find Object Or Library
Nov 6, 2009
I am trying to run a macro that i have copied from another workbook (which works fine) and when i try to run the macro i am getting a 'compile error' which says "Can't Find Object or Library" and takes into VB editor which highlights the word "Trim", which is part of a formula. What does this mean? I can't understand why the same macro will work in another workbook but not in this one. Below is the full code, I would have attached the workbook but it would not work for you as it opens and saves files that you would not have. Hopefully someone can understand from the code.
View 10 Replies
ADVERTISEMENT
Apr 28, 2009
I have a workbook that is used by a number of different users accross the company. Some people have PC's running Windows 2003 SP3, some have terminals with either
- Windows 2000 SP4 with Excel 2002 SP3
or
- Windows 2003 SP2 with Excel 2002 SP3
on the server.
On the "Windows 2003 SP2 with Excel 2002 SP3" example the code below won't run.
Saying "Compile Error in hidden module." I unlocked the code and re-ran the "Workbook_Open" event but I keep getting "Compile Error: Can't find project or library". I have then checked the references but none have the "Missing" prefix, so I don't know which to look for. Does anyone know what DLL i need to load or should I just get IT to updgrade to SP3?
Code: ....
View 9 Replies
View Related
Jul 24, 2007
I am working on a form in VB and when I try to enter data into Textboxes (which all have either a currency format or date format) I get an error that says "Compile Error - Can't find project or library". I think the problem may be that I need additional references uploaded onto my VB but am not sure. Any Ideas?
View 6 Replies
View Related
Mar 4, 2014
One of our employees has wrote a VB project in excel 2010 which works on some machines and not others, it comes up with the below error message.
I have checked VB and there are no missing references.
Compile Error: Can't find project or library
Private Sub UserForm_Initialize()
'Empty ClientCodeComboBox
Me.ClientCodeComboBox.Clear
[Code] .....
View 14 Replies
View Related
Oct 1, 2006
I have the following
Private Sub Workbook_Open()
Worksheets("Sheet1"). Range("L5").Value = Date
End Sub
When i try and run the code it returns an error saying: "Compile Error, Cant Find Project Or Library" and it highlights the word "Date"
View 7 Replies
View Related
Jun 11, 2009
HI everyone I modified my code alot and now it is erroring out on me. This button in question basically saves the information collected to a new spreadsheet. But it errors at right at the start. Compile Error: Can't Find project or library.
View 3 Replies
View Related
Apr 30, 2007
Below is a string of code that used to previously work in my excel workbooks. Currently, I have been receiving the following message: "Compile error: Can't find project or library" when it reaches the SolverReset. Solver has been added to my excel version, but I still can't figure out why it isn't working. I have looked through the references and noticed that the Solver is missing within VBA, unfortunately, I cannot seem to add the reference back in, it is no longer on the list of references.
Sub Macro1()
Dim myNum As Long
Dim answer As Byte
Sheets("Data Sheet").Select
For myNum = 2 To 42
SolverReset
SolverOk SetCell:="$C$" & myNum, MaxMinVal:=3, ValueOf:="0", ByChange:="$E$" & myNum
answer = SolverSolve(True, "ShowTrial")
SolverFinish KeepFinal:=1
Next myNum
End Sub
View 3 Replies
View Related
Jun 5, 2007
For some reason, I'm getting a "Compile Error: Can't Find Project Or Library" error on things that I shouldn't. So far, I've gotten this on Left(), Right() and Format(). I downloaded an example form from somewhere, and I noticed that it uses Format() without any problems, but if I use it (even if I just copy and paste they're code into my project file) it gives the above error. What I'm wondering is if there is a fix, or some reason why I'd have this problem on one file and not another. Then, more importantly, is there any kind of work around, for example I happened to read on another unrelated thread that xl97 doesn't have a Replace() function, but you could use the worksheet function: application.worksheetfunction.substitute(text, " ", "_") instead. Is there anything like this for Left(), Right() and Format()?
View 2 Replies
View Related
Mar 22, 2007
I am using Mid function in my program. During execution, i am getting the waring message of "Complier Error: Cann't find project or library".I am not able to find the what is the reason behind on it. If really the library file missing.
View 3 Replies
View Related
Nov 6, 2007
I have currently written a macro in excel 2003, it doesn't run on excel 2007, or some versions of 2003, I realize this is due to missing references, I was curious if there is any way to write code to actually prompt or install these references using VB. This way novice users can use the macro by themselves.
At the moment it fails on code such as
ans = MsgBox("??", vbYesNoCancel, "Title")
saying ans is not found
"Compile Error: Project or Library cannot be found"
I can avoid these errors by dimensioning everything as a string or variant. BUt doing this will use more memory which is not desired at the moment as it sometimes exhuast available memory on some machines.
View 9 Replies
View Related
Oct 21, 2006
I added this code to a userform initialize & now I get a message ' can't find object or library '. Which library do I have to activate in Tools, References.
Dim x As Integer
ComboBox1.AddItem "0"
For x = 1 To 20 Step 1
ComboBox1.AddItem Format(x, "0")
Next x
ComboBox1.Value = Sheet2.Range("E1").Value
ComboBox2.AddItem "0"
For x = 2 To 90 Step 2
ComboBox2.AddItem Format(x, "0")
Next x
ComboBox2.Value = Sheet2.Range("E2").Value
The word Format is highlited in userform initilize.
View 9 Replies
View Related
Mar 19, 2013
I have an application that will require I create 20+ objects from a class I have created call "cWorkCenter." This is my first project using objects in VBA. I've created a string variable called "Title." THe application will loop through a list of resources on a worksheet, assign the name of that resource to the variable called "Title" (eg. Title=Range("A1")), then create an object named whatever the string is that "Title" represents. For example, if the first item in my list is "Resource1", then the first object created should be called "Resource1"
When I do this I get the following error: Compile Error: Duplicate declaration in current scope.
Below is the part of the code giving me trouble.
VB:
Public Title As String
Sub Loader_OO()
Title = "Resource1" [code].....
View 2 Replies
View Related
Dec 4, 2007
I found this code in the Mr. Excel archives. It is designed to add a sequential number to a cell if the cell next to it contains text and then stop as soon as it encounters a blank. Problem is that I keep getting a Compile Error: Object Required on the Set nos line. I tried using a qualifier and also expirimented with CreatObject but still received the error.
Sub AddNos()
Set nos = Range("B1", Range("B1").End(xlDown)).Offset(0,-1)
nos.Resize(1,1).Value = 1
nos.Resize(1,1).AutoFill nos, xlFillSeries
nos.NumberFormat = "General""."""
End Sub
View 4 Replies
View Related
Oct 19, 2006
I'm having trouble releasing a String variable from Memory...
View 9 Replies
View Related
Jul 6, 2007
I am using the calendar control on a form of mine, which i believe requires ms access to be installed to use(from what ive read). This is fine as most of the PC's it will be run on have this installed. However if it is run on a PC that doesnt have ms access it gives me the "Could not load an object because it is not avaliable on this machine" and then "cant find project or library error". How can I trap this error ? Ive tries whe the workbook opens, and when the form initializes but it just brings up that error
View 2 Replies
View Related
May 25, 2014
It works fine with several versions of Excel (2003, 2010, and 2013). But the problem arises when I move from Windows XP to Windows 7 or 8.
I use a scanner to scan barcode serial numbers into a textbox, and then populate these serial numbers with other associated data into a spreadsheet. The serial numbers are supposed to be separated by each line and placed into an array.
I get a compile error "Cant find project or library" with CHR highlighted in blue from this line of code...
SNs = Split(Str, Chr(10))
Once again, it works fine on many machines with XP, but not on Win 7 or 8.
[Code] .....
View 4 Replies
View Related
Jun 29, 2014
I have the below code which was working at work using Excel 2010. We have upgraded to Office 2013 and it no longer works
Error: Compile Error. Cant find Project or Library
It does highlight this : If Right(varFile, 4) = ".xls" Then
Code:
Sub PropertyName_SAVEAS()
Sheets("Menu").Select
Range("I27").Select
Dim varFile As Variant
Dim strFileNameDefault As String
On Error Resume Next
[Code] .......
View 2 Replies
View Related
Jan 17, 2005
I'm getting the following error:
"Object library invalid or contains references to object definitions that could not be found"
I wasn't getting that error last night and I'm not sure what I may have done to cause this error.
It seems to be cause by code running on one sheet of my workbook, but I'm not really sure about that. I'm still a bit of a novice at VBA.
I'm using Excel 2002 SP3 and I'm running MS XP Home as my OS.
Do you have any ideas what can cause this error and/or how to trace down the offending objects/code?
View 9 Replies
View Related
Sep 28, 2007
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.
View 9 Replies
View Related
Mar 31, 2009
I am trying to use the Find function within some VBA code but keep encountering a compile error. Code works fine on it's own as below but doesn't work within the VBA code. I can't figure out what part of code needs to be modified.
The desired result in J2 = "Jim"
the value in cell I2 = "Jim |Anderson"
Working Function as follows:
View 3 Replies
View Related
Feb 15, 2007
how you know which object library to add to references when you want to automate an application?
for example Adobe acrobat.
or internet explorer ( ie).
I know that the .dll for ie id shdocvw (an i know it's explicitly listed under internet controls) but how would i know this is it wasn't listed?
Also, correct me if i'm wrong, but usung the shdocvw.dll will only give you access to the main controls of Ie nd you would need to add a HTML library to do anything use full. How do you know if there are other libraries available can make the 'usefulness' of one library more useful?
View 9 Replies
View Related
May 5, 2014
Our office has different versions of Office on different computers. We have a file containing macros specifically macros that interact with Outlook requiring the Outlook Object Library. If a 2013 opens and saves the file all the libraries get changed to 15.0. Then a 2010 Office opens the file ... the Excel Objects and Office Objects libraries change to 14.0 because of 2010, but then we getting the error about missing library. Instead of loading the Outlook 14.0 Object Library like it's supposed to the systems tries to find the 15.0, but can't find it and throws the error.
I have to manually go in to References and uncheck the Missing 15.0 outlook library and find and check the 14.0 one and click ok then the macros work fine.
My question is why do the other object libraries automatically change depending on the version of office and the outlook one doesn't.
Interestingly enough this doesn't happen the other way e.g. 2010 to 2013. Ones the file is saved using the 2010 with the 14.0 references 2013 has no issues converting those references to 15.0.
View 2 Replies
View Related
Apr 9, 2012
I am trying to make an excel vba reference the word 12.0 object library automatically without the user having to manually add them. How I can do this?
View 2 Replies
View Related
Jun 27, 2014
I have this vba that copies the current sheet and renames it as well as copying the current sheet into a new workbook for emailing.
This has worked fine for the last 2 years or so but all of a sudden it doesn't want to work. The error message is that it "Can't find project or library."
Code:
Dt = Format(Range("C19").Value + 6, "DDMMYYYY")
Dt is dimmed as string and Dt is used to rename the new sheet.
I have looked througn the reference library and things seem ok.
This happens in Excel 2003 with Win8 and in excel 2013 with Win7.
View 3 Replies
View Related
May 27, 2006
i'm using a user form and i have the microsoft forms 2.0 Object Library checked. i have sent to another user, and i can't compile, when i took at this vba tools reference, microsoft forms 2.0 Object Library checked is missing (and not available in the drop down)...?
View 2 Replies
View Related
Oct 5, 2007
In a workbook made in Excel 2003, I have the following for a UserForm:
Private Sub UserForm_Activate
Me.Calendar1.Value = Date
End Sub
I copied this workbook to a computer with Excel 2007 and it bombs out at "Date"
It comes up with a compile error, "Can't find project or library"
In the references window (Tools, References) it has the "Missing: Ref Edit Control" checked and the location at the bottom of this window states "C:Program FilesMicrosoft OfficeOffice11REFEDIT.DLL".
The reference to Office11 is from the computer with Office 2003 as the computer with Office 2007 has Office12.
There is another "Ref Edit Control" in the References window and when I check it and browse to the Office12 folder, highlight REFEDIT.Dll and click on open and in the references window on OK it comes up with "Name conflicts with existing module, project or object library". I have tried to delete the "Missing: Ref Edit Control", change the priority and change the reference in the missing control to Office12 but all to no avail.
How can I change the reference to the Ref Edit Control from Office11 to Office12?
View 3 Replies
View Related
Feb 7, 2007
I am trying to run create a simple macro that copies and paste special values - something I have done 100's of times but for some reason I keep getting an error message - even though I recorded the macro and didnt write it by hand - see below:
Sub Macro6()
Cells.Select
selection.Copy
selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
For which I get 'Compile Error - Expected Function or Variable'
View 6 Replies
View Related
Apr 26, 2006
I have some code that, although works fine in Excel 2003, does not in Excel 1997. I receive this error when I try running it:
COMPILE ERROR:
NAMED ARGUMENT NOT FOUND
Sub HPVAL()
Dim r As Range, myStr As String
myStr = "HP"
Set r = Cells. Find(What:=myStr, After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False)
If Not r Is Nothing Then
r = r.Value
While Not r Is Nothing
Set r = Cells.FindNext(r)
If Not r Is Nothing Then
r = r.Value
End If
Wend
End If
End Sub
It looks like Excel is getting hung up on the "SearchFormat:=" portion of the code.
View 2 Replies
View Related
May 20, 2009
I am looking for a more efficient way to write a macro (a sample from the macro is below). This is just the first part of the macro. I need to repeat these same steps (seen for row 5 below) for rows 5 to 50. My script worked until I hit row 35 and then I got the "compile error.." message. There must be a way to use "loop" to write this more efficiently, no?
View 14 Replies
View Related
Feb 2, 2010
I am getting the error from the title of the thread when I try to change a worksheet name.
This worksheet name doesn't already exist in the workbook and I don't have any other files currently open.
I'm not entirely sure what is causing this, but I do need the sheet to be the name I am trying to change to.
View 9 Replies
View Related
