View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Opening an already existant Word document with an Excel Macro

Dim oWord as Object
Dim oDoc as Object

Set oWord = CreateObject("Word.Application")
oWord.Visible = True

Set oDoc = oWord.Documents.Open("C:\personal\bob\personal\CV - RP
(short).doc")


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Tan" wrote in message
...
Hi,

I need to open a specific Word document while running an Excel macro. Up
until now, I've been able to open a new document in Word :

Application.ActivateMicrosoftApp xlMicrosoftWord


Any ideas on how to accomplish that?
Thanks!