ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   call .DOC from an Excel VBA macro ? (https://www.excelbanter.com/excel-programming/284076-call-doc-excel-vba-macro.html)

Ayato

call .DOC from an Excel VBA macro ?
 
How to call a wod document file from an Excel vba code ?




Don Guillett[_4_]

call .DOC from an Excel VBA macro ?
 
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

--
Don Guillett
SalesAid Software

"Ayato" wrote in message
.. .
How to call a wod document file from an Excel vba code ?







All times are GMT +1. The time now is 02:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com