?
Solved

VBA compile error due to library

Posted on 2016-11-02
3
Medium Priority
?
37 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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…
Suggested Courses

762 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