creates a new instance of Word and then opens and makes visible an existing Word document: : Binding « Excel « VBA / Excel / Access / Word






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

creates a new instance of Word and then opens and makes visible an existing Word document:

 
Sub WordLateBinding()
    Dim wdApp As Object, wdDoc As Object
    Set wdApp = CreateObject("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.After the reference is set, Word variables can be declared with the correct (Word) variable type.
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.