Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
tan tan is offline
external usenet poster
 
Posts: 29
Default Opening an already existant Word document with an Excel Macro

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!

  #2   Report Post  
Posted to microsoft.public.excel.programming
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!



Reply
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
stop error message when opening a non existant file in a macro swar phil Excel Discussion (Misc queries) 1 March 22nd 10 02:35 PM
Opening a Word Document using an Excel (2000) Macro? ekreider Excel Discussion (Misc queries) 4 January 5th 08 04:41 AM
Opening word document through excel vba srinums Excel Discussion (Misc queries) 0 June 8th 06 12:02 PM
opening a word document from excel chris Excel Programming 5 April 1st 04 03:17 PM
Opening a Word Document in Excel Tonja Excel Programming 2 September 18th 03 02:56 AM


All times are GMT +1. The time now is 10:29 PM.

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

About Us

"It's about Microsoft Excel"