Dynamic References to Word?
Thanks a lot RB Smissaert !
1° - Does this procedure work if Word 2000 is installed as well with Word
2003 installed?
2° - I need to remove the reference because another VBA procedure (which
doesn't uses Word) hangs if the reference is still there!
Thanks again !
Newbie
"RB Smissaert" a écrit dans le message de
...
Sub ActivateWordLibrary()
Dim R
On Error Resume Next
'no need to carry on if the Word Object Library is already there
'---------------------------------------------------------------
For Each R In ThisWorkbook.VBProject.References
If R.GUID = "{00020905-0000-0000-C000-000000000046}" Then
Exit Sub
End If
Next
ThisWorkbook.VBProject.References.AddFromGuid _
GUID:="{00020905-0000-0000-C000-000000000046}", _
Major:=0, Minor:=0
On Error GoTo 0
End Sub
You can remove the reference after, but not really neccessary.
RBS
"Newbie" wrote in message
...
Hello
As the Late Binding seems very slow, I would like to create a reference
on
Word 2000 or Word 2003 (Several PCs are running Office 2000, some others
are
running Office 2003.
How can i create a Reference for Microsoft Word 9.0 or for Microsoft
Word
11.0 (2000 and 2003)?
How to remove this Reference after the VBA procedure has done its work?
Thanks
|