starting Word from an Excel macro

  • Thread starter Thread starter Russ
  • Start date Start date
R

Russ

I found this piece of code by Bob Phillips that opens a Word document from
within 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")

It works fine but it also closes the Excel file that contains the macro. Is
there a way to prevent the Excel file from closing?
 
Russ,

There's nothing in that snippet that will close the Excel Application. I
think you need to post all your code.

Mike
 
Nothing I can see in that code would cause Excel or the workbook to close.

Lose focus, yes, close, no.

At least not in my testing.


Gord Dibben MS Excel MVP
 
What version of excel are you using?
I found this piece of code by Bob Phillips that opens a Word document from
within 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")

It works fine but it also closes the Excel file that contains the macro. Is
there a way to prevent the Excel file from closing?
Click to expand...
 

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

starting Word with an Excel macro 2
excel macro to open word doc besed on user selection 1
passing variables from excel to word 9
excel vba word merge printer error 2
Control Word through Excel 1
Renaming a Word document from text in controls 2
Pass control name to Word 1
how to control word from excel 1

Back
Top