Conernesto
asked on
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
Conernesto
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In addition to Rey's suggestion, you should consider using late binding.
ASKER
I unchecked missing Excel 2015. I also checked Microsoft Excel 14.0 Object Library and my compile error went away. Thank you.