Thread: [Solved] Adding reference to Office 12 Object Library to
View Single Post
 
Old 02-20-2018, 02:37 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote