Use Office 14 Library with Access 2010 Runtime

Question

I would like to set references to the Microsoft Office and Excel 14.0 Object Library(s) in an application to be distributed with the Access 2010 runtime.  Assuming that some users may have an earlier or no version of Office installed, how do I include them in my installation?

Thanks!

terri

Answer 1

Don't set references and change your code to use LATE BINDING and then it will not matter what version someone has.  It should all work quite well (unless you use file formats that are not compatible with previous versions - for example creating an XLSX file but someone only has Excel 2003 without the compatibility pack installed).

---

Bob Larson, Access MVP 2008-2010, 2011

Answer 2

terri_k wrote:

I would like to set references to the Microsoft Office and Excel 14.0 Object Library(s) in an application to be distributed with the Access 2010 runtime.  Assuming that some users may have an earlier or no version of Office installed, how do I include them in my installation?

To add to Bob's posting see the "Late Binding in Microsoft Access" page
at http://www.granite.ab.ca/access/latebinding.htm

Tony

---

Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files   updated see http://www.autofeupdater.com/