Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. 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