Adding reference to Office 12 Object Library to

macropod · #9 02-20-2018, 02:37 PM

While it is true that no library references need be added for code that's not doing any automation, they are needed for early binding with automation. Automation code compiled for newer libraries cannot be guaranteed to work with earlier ones. As advised by Microsoft (https://support.microsoft.com/en-us/...n-automation):

Quote:

If you need to automate an Office application, it is recommended that you early bind to the earliest version of the product that you expect could be installed on your client's system. For example, if you need to be able to automate Excel 95, Excel 97, Excel 2000, and Excel 2002, you should use the type library for Excel 95 (XL5en32.olb) to maintain compatibility with all three versions.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Microsoft Excel 12.0 Object Library reference upload	chamdan	Project	2	04-21-2014 06:30 AM
Let Office Object Library 14.0 work in Office 2007	tinfanide	Word VBA	14	12-23-2011 02:43 PM
Excel VBA: How to add a reference to Microsoft Word Object Library?	tinfanide	Excel Programming	7	12-12-2011 05:21 AM
Problem: object library invalid or contains references to object definitions	aligahk06	Office	0	08-19-2010 12:29 PM
Access Object library 10	Gyto	Office	0	10-09-2008 09:04 AM