Thanks Jezebel.
Since it is possible from the Run dialog box to start Word and run a
macro in one step, I'm thinking that if, with Word open but not active,
I ran the macro I'm looking for, I could get a macro that activated the
open Word window without opening a second instance of Word.
However, when I create a macro in Normal called WordActivate using the
code you suggested,
Dim wrdApp as object
On error resume next
Set wrdApp = GetObject("Word.Application")
and (with Word open but not active) run this in the Run dialog box:
Winword.exe /mWordActivate
A second instance of Word opens.
The same happens when I put the other set of code in WordActivate.
Any other ideas? Thanks much.
Larry
Jezebel wrote:
If you mean from VB, there are two methods --
1) Late binding
Dim wrdApp as object
On error resume next
Set wrdApp = GetObject("Word.Application")
If wrdApp is nothing then
.... Word was not running .... no instance to get
or 2) Early binding
Dim wrdApp as Word.Application
On error resume next
Set wrdApp = Word.Application
If wrdApp is nothing then
.... Word was not running .... no instance to get
"Larry" wrote in message
...
I would be great to find a way to activate Word without starting a
new Word instance. I think I asked about this a year or two ago,
and didn't get anywhere. Any ideas?
|