• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 51
  • Last Modified:

VBA compile error due to library

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
Conernesto
Asked:
Conernesto
1 Solution
 
Rey Obrero (Capricorn1)Commented:
Open the Tools > References and look for "MISSING" ref
uncheck and select the reference for Excel 2013
0
 
MacroShadowCommented:
In addition to Rey's suggestion, you should consider using late binding.
0
 
ConernestoAuthor Commented:
I unchecked missing Excel 2015. I also checked Microsoft Excel 14.0 Object Library and my compile error went away. Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now