ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Refencing a Microsoft WORD Library in EXCEL VBA (https://www.excelbanter.com/excel-programming/342593-refencing-microsoft-word-library-excel-vba.html)

mark

Refencing a Microsoft WORD Library in EXCEL VBA
 
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

Refencing a Microsoft WORD Library in EXCEL VBA
 
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" wrote in message
oups.com...
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

Refencing a Microsoft WORD Library in EXCEL VBA
 
Would you be kind enough to explain how this is done, please?

Mark


Rowan Drummond[_3_]

Refencing a Microsoft WORD Library in EXCEL VBA
 
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



All times are GMT +1. The time now is 02:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com