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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA in Citrix. 0
Open Word Document using VBA in Excel 6
starting Word with an Excel macro 2
Pasting Selected Excel Cells into a Word Doc 1
Calling Excel shortcuts from VBA 1
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Word to Excel: Export comments with text and line number 0
Open a word mail-merge document from Excel VBA 1

Back
Top