Opening an already existant Word document with an Excel Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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)
 

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

Performing ms word operations from ms Excel. 1
Open Word Document from Excel 1
How can I open a named Word doc from an Excel macro 2
Opening Word with a specific document from excel vba 5
Open Excel 3
Transfer Excel data to Word 1
Accessing Word from Excel 4
Custom Document Properties in Word documents and Excel workbooks 13

Back
Top