Hi kaiser,
kaiser wrote:
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]