Excel VBA: How to add a reference to Microsoft Word Object Library?

tinfanide · #1 12-12-2011, 03:46 AM

Thanks for the binding reminder.

It seems to work without the reference.
In Excel VBA:

Code:

Sub lateBinding()

' no need to set reference to MS Word Object Library
Dim wrdApp As Object
Set wrdApp = CreateObject("Word.Application")
Dim wrdDoc As Object
Set wrdDoc = wrdApp.Documents.Add

wrdApp.Visible = True
wrdDoc.Sections(1).Range.Delete

With wrdDoc
    .Paragraphs.Add
    .Paragraphs(1).Range.Text = "Late Binding: no need to set reference to MS Word Object Library"
End With

Set wrdDoc = Nothing
Set wrdApp = Nothing

End Sub

Colin Legg · #2 12-12-2011, 05:21 AM

Quote:

Originally Posted by tinfanide

Thanks for the binding reminder.
It seems to work without the reference.

Yes, exactly.

There are several disadvantages to using late binding: slightly slower performance and loss of intellisense. The loss of intellisense is quite an impediment during the development phase, which is why I recommend that you develop the project using early binding and then convert to late binding just before final testing and deployment.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
option Paste special...as 'Microsoft Excel Chart Object' NOT available	Intruder	PowerPoint	0	12-24-2010 06:28 AM
Problem: object library invalid or contains references to object definitions	aligahk06	Office	0	08-19-2010 12:29 PM
Problem with my microsoft word com object in c# web application	Naresh_1210	Word VBA	0	03-11-2010 12:26 AM
Inserting citations using the reference function in Microsoft Word 2007?	aeyara	Word	0	09-28-2009 05:33 PM
Access Object library 10	Gyto	Office	0	10-09-2008 09:04 AM