LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
That I do I cannot open to archives in Word nor Excel? Antonio New Users to Excel 1 February 12th 07 11:35 PM
Excel Hyperlink doesn't open Word doc the same way as Word does duugg Excel Discussion (Misc queries) 2 October 12th 06 03:14 PM
How to open a word doc while in Excel Katie Excel Discussion (Misc queries) 5 February 21st 06 07:56 PM
Graph Excel Selection, Open Word File, Embed Graph Into Word Steve Excel Programming 0 November 17th 03 05:35 PM
In Excel VBA, open .txt with Word? Ed[_9_] Excel Programming 4 October 30th 03 05:42 PM


All times are GMT +1. The time now is 06:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"