UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Fix Missing Reference, Access 2007    
 
   
NineIron
post Sep 9 2019, 06:13 AM
Post#1



Posts: 2,145
Joined: 18-September 03
From: Massachusetts


I need to update an access db written by someone else. When I try to use the db, I get a missing reference: Microsoft Excel 14.0 Object Library. How can I fix this?
Go to the top of the page
 
Phil_cattivocara...
post Sep 9 2019, 06:20 AM
Post#2



Posts: 364
Joined: 2-April 18



Uncheck the missing reference, close the file. Reopen, go to the same windows and search Microsoft Excel xx.0 Object Library. Check and confirm with OK. (double click is not sufficient)
To prevent this trouble modify your code using latebinding which does not require that kind of reference.

--------------------
Please forgive in advance my horrible English.
Go to the top of the page
 
NineIron
post Sep 9 2019, 06:25 AM
Post#3



Posts: 2,145
Joined: 18-September 03
From: Massachusetts


Pardon my ignorance but, where do I search for the the object library?
Go to the top of the page
 
Phil_cattivocara...
post Sep 9 2019, 07:17 AM
Post#4



Posts: 364
Joined: 2-April 18



Go to Visual Basic Editor (ALT + F11), Tools - References. Here you have the whole list. You must have Excel installed to find it there.

--------------------
Please forgive in advance my horrible English.
Go to the top of the page
 
NineIron
post Sep 9 2019, 07:30 AM
Post#5



Posts: 2,145
Joined: 18-September 03
From: Massachusetts


I have EXCEL 2007 on my machine. In the list of References: MISSING: Microsoft Excel 14 Object Library. I've attached a screen shot.


Attached File(s)
Attached File  Doc1.zip ( 62.07K )Number of downloads: 5
 
Go to the top of the page
 
ADezii
post Sep 9 2019, 07:46 AM
Post#6



Posts: 2,680
Joined: 4-February 07
From: USA, Florida, Delray Beach


If my numbers are correct Excel 2007 is Version 12 while Excel 2010 is Version 14.The current Reference to the Excel Object Library must have been set in Excel 2010 which is a higher Version then you are working in. Remove the Reference to the Microsoft Excel 14.0 Object Library and replace it with a Reference to the Microsoft Excel 14.0 Object Library.
This post has been edited by ADezii: Sep 9 2019, 07:47 AM
Go to the top of the page
 
Phil_cattivocara...
post Sep 9 2019, 07:47 AM
Post#7



Posts: 364
Joined: 2-April 18



You arrived to the right window. Now follow these passes
1) Uncheck the missing reference and press OK.
2) Reopen that window: the missing reference must be desappeared.
3) In the same windows scrool down that list (do not click on Browse... )
4) When you find Microsoft Excel 12.0 Object Library, check it and Press OK.
To be sure everything is ok, from menu: Debug - Compile.
This post has been edited by Phil_cattivocarattere: Sep 9 2019, 07:48 AM

--------------------
Please forgive in advance my horrible English.
Go to the top of the page
 
NineIron
post Sep 9 2019, 07:49 AM
Post#8



Posts: 2,145
Joined: 18-September 03
From: Massachusetts


I'm not sure I understand. Remove the Office 14 Object library then, replace with Office 14 Object library?
Go to the top of the page
 
Phil_cattivocara...
post Sep 9 2019, 07:54 AM
Post#9



Posts: 364
Joined: 2-April 18



I think ADezii had a typo. Read my list and follow it, then let us know if you have problema again.
This post has been edited by Phil_cattivocarattere: Sep 9 2019, 07:54 AM

--------------------
Please forgive in advance my horrible English.
Go to the top of the page
 
NineIron
post Sep 9 2019, 08:21 AM
Post#10



Posts: 2,145
Joined: 18-September 03
From: Massachusetts


Wonderful. It works. Thanx.
Go to the top of the page
 
BruceM
post Sep 9 2019, 08:25 AM
Post#11


UtterAccess VIP
Posts: 7,971
Joined: 24-May 10
From: Downeast Maine


In any case you should compile the code and identify where the failure occurs. There may be a better option than adding the Excel reference library.

Late binding may be preferable. This article describes it well.
Go to the top of the page
 
GroverParkGeorge
post Sep 9 2019, 08:32 AM
Post#12


UA Admin
Posts: 35,902
Joined: 20-June 02
From: Newcastle, WA


Attached File  ExcelReferences.jpg ( 9.21K )Number of downloads: 0

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
geoffk7828
post Sep 11 2019, 01:20 AM
Post#13



Posts: 25
Joined: 21-October 06
From: Barossa Valley South Australia, Australia


Thanks you for the replies, greatly appreciated.

Geoff
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    24th October 2019 - 12:20 AM