Creating and Referencing Objects : Binding « Excel « VBA / Excel / Access / Word

Creating and Referencing Objects

Sub UseGetObject()
    Dim wdDoc As Object
    Set wdDoc = GetObject(ThisWorkbook.Path & "\Word.docx")
    wdDoc.Application.Visible = True
    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.creates a new instance of Word and then opens and makes visible an existing Word document:
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.