Refencing a Microsoft WORD Library in EXCEL VBA

[Mark]

I am using two different versions of EXCEL and I need to be able to
reference different veriosns of Microsoft WORD Library, Ver 8 for
Office 97 and Ver 10 for Office 2000. Is there a way with VBA to do
this, if so can someone help me with some code, please?

Thanks

Mark

 

[NickHK]

Mark,
Don't reference either library, use late binding, CreateObject etc.
Design it to work in Ver. 8 and then Ver.10 should be OK.

NickHK

 

[Mark]

Would you be kind enough to explain how this is done, please?

Mark

 

[Rowan Drummond]

This should point you in the right direction:

http://www.xldynamic.com/source/xld.EarlyLate.html

Hope this helps
Rowan