call .DOC from an Excel VBA macro ?

  • Thread starter Thread starter Ayato
  • Start date Start date
Here is one I use this time of year

Sub OpenDocument()
Dim wdApp As Word.Application
strFilename = "XmasListEnvelopes1.doc"
Set wdApp = CreateObject("Word.Application")
With wdApp
.Documents.Open Filename:=ThisWorkbook.Path & "\" & strFilename
.Visible = True
End With
Set wdApp = Nothing
End Sub
 
Back
Top