11-05-2021
Microsoft Excel 15.0 Object Library Download
What if you save the Project with Object Library 14.0? That should be accessible from both Excel 2010 and Excel 2013. When programming with VBA in Excel, it is usually best to program it using references/VBA code from the oldest version of Excel that may be using it.
Microsoft Excel 15.0 Object Library Download
I have a MS Access project that references the MS Excel 15.0 Object Library (Excel 2013). When my coworkers with Excel 2010 try to use Sub Procedures contained in Database they get a project library not found error. I went and personally changed the object library on several users machines to the 14.0 Object Library. This fixed the problem yesterday but, when they logged in today they get the same error message.
Is there a way to check Application.Version and reference a different library programatically based on there excel version.
i.e.
Free Excel Download
- Hi, The version of the Outlook Object library varies with the version of Office installed; for example Office 2010 has version 14.0. When you create a macro using references in a 'lower' version and copy it to a higher version of office the reference numbers are automatically updated, this is NOT the case the other way around.
- Thanks for the post. I do have web components 2003 installed. But what I added on my dev machine was a DLL called Microsft Excel 12.0 Object Library.