After the reference is set, Word variables can be declared with the correct (Word) variable type. : Binding « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Binding

After the reference is set, Word variables can be declared with the correct (Word) variable type.

 
Sub WordEarlyBinding()
    Dim wdApp As Word.Application
    Dim wdDoc As Document
    Set wdApp = New Word.Application
    Set wdDoc = wdApp.Documents.Open(ThisWorkbook.Path & "\Word.docx")
    wdApp.Visible = True
    Set wdApp = Nothing
    Set wdDoc = Nothing
End Sub








Related examples in the same category

1.An Example of Early Binding
2.Using the CreateObject Function to Create a Late-Bound Instance of Excel
3.Late Binding
4.Early vs. Late Binding
5.creates a new instance of Word and then opens and makes visible an existing Word document:
6.Creating and Referencing Objects
7.If multiple versions of Word are installed, you can create an object for a specific version. The following statement, for example, uses Word 97.