Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make excel the active page
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make excel the active page
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] |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make excel the active page
thanks - that worked 100%
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Make Excel the active application | Excel Discussion (Misc queries) | |||
excel press enter to make active on 1st colum in new row | New Users to Excel | |||
How do I make the border of an active cell in Excel darker? | Excel Discussion (Misc queries) | |||
Can I make a Excel Active Desktop Worksheet on XP? | Excel Discussion (Misc queries) | |||
Excel 2003 - referenceing the active worksheet page in vlookup | Excel Worksheet Functions |