Solved

VBA compile error due to library

Posted on 2016-11-02
3
25 Views
Last Modified: 2016-11-02
I recently updated Excel to Excel 2013. I am running some code in Access that required Microsoft Office 11.0 Object Library. The Compile error is : Can't find project or library. Do you know if I need to update the object and how do I do this?

Conernesto
0
Comment
Question by:Conernesto
3 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 41870610
Open the Tools > References and look for "MISSING" ref
uncheck and select the reference for Excel 2013
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 41870781
In addition to Rey's suggestion, you should consider using late binding.
0
 

Author Closing Comment

by:Conernesto
ID: 41870886
I unchecked missing Excel 2015. I also checked Microsoft Excel 14.0 Object Library and my compile error went away. Thank you.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now