open word doc from within excel with VBA
 

How can I open a word document from within excel with VBA and minimize the
document.

open word doc from within excel with VBA
 

Excel can't open Word documents, although the reverse is not the
case. You can automate Excel to open Word, and then have Word
open a document and minimize itself. E.g.,



Dim WDApp As Object
Dim WordDoc As Object
Set WDApp = CreateObject("Word.Application")
WDApp.Documents.Open Filename:="H:\Test.doc"
WDApp.WindowState = wdWindowStateMinimize



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Luc" wrote in message
...
How can I open a word document from within excel with VBA and
minimize the
document.