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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[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

Mark wrote:
> Would you be kind enough to explain how this is done, please?
>
> Mark
>