?
Solved

VBA compile error due to library

Posted on 2016-11-02
3
Medium Priority
?
40 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
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…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

650 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