Make excel the active page

[kaiser]

Hello,

I have a macro that takes the contents of a column of cells, opens a
word docuemtn, searches through the word document and replaces some of
the words that I specified in Cell A1 with the contents of A2.

The only problem is that the macro makes Word the active program while
the marco runs but I would rather have word as the active program for
while the macro runs...any way that I can force this excel to be the
program the user see's? or perhaps is there a way NOT to activate word
window as the excel window is already active?

 

[Jake Marx]

Hi kaiser,

I have a macro that takes the contents of a column of cells, opens a
word docuemtn, searches through the word document and replaces some of
the words that I specified in Cell A1 with the contents of A2.

The only problem is that the macro makes Word the active program while
the marco runs but I would rather have word as the active program for
while the macro runs...any way that I can force this excel to be the
program the user see's? or perhaps is there a way NOT to activate
word window as the excel window is already active?

How are you opening/manipulating the Word doc? Via automation? If that's
the case, you should be able to set the Word application's Visible property
to False - that way, everything will be done in the background, and user
won't see Word at all. If that's not possible, you could try the
AppActivate function.

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

 

[kaiser]

thanks - that worked 100%