Client using 97 & XP
 

Hi,
I have developed an Excel add-in that references the word
object library. However, some of my clients machines use
Office XP and some 97 so I have problems with missing
libraries if I reference 8.0 libraries and run it on an XP
machine and vice versa.
Is there a way to set the references in code based on the
version of Excel being used or another work around?

Thanks,
Mark

Client using 97 & XP
 

Use late binding - don't have a reference to excel.

http://support.microsoft.com/default...b;EN-US;244167
INFO: Writing Automation Clients for Multiple Office Versions

http://support.microsoft.com/default...b;en-us;245115
INFO: Using Early Binding and Late Binding in Automation

http://support.microsoft.com/default...b;en-us;247579
INFO: Use DISPID Binding to Automate Office Applications Whenever Possible


--
Regards,
Tom Ogilvy

"Mark Heyhoe" wrote in message
...
Hi,
I have developed an Excel add-in that references the word
object library. However, some of my clients machines use
Office XP and some 97 so I have problems with missing
libraries if I reference 8.0 libraries and run it on an XP
machine and vice versa.
Is there a way to set the references in code based on the
version of Excel being used or another work around?

Thanks,
Mark