Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bringing Excel to the front
Does VBA have a method for bringing the application window to the front? I
can do it with the Windows API but I'm hoping for a simpler solution, like an "Activate" or "SetFocus". TIA -- Scott Holmes |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bringing Excel to the front
There's an ActivateMicrosoftApp method. Maybe this will do what you want.
On Mon, 25 Aug 2003 00:29:45 -0500, "Scott Holmes" wrote: Does VBA have a method for bringing the application window to the front? I can do it with the Windows API but I'm hoping for a simpler solution, like an "Activate" or "SetFocus". TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bringing Excel to the front
This caused the excel icon on the taskbar to flash:
Application.Wait Now + TimeSerial(0, 0, 5) AppActivate Application.Caption (the .wait gave me time to activate a different program.) Scott Holmes wrote: I saw that one, but there is no constant for Excel. Thanks anyway -- Scott Holmes Cornerstone Solutions, Inc. 713-661-5200 "Myrna Larson" wrote in message ... There's an ActivateMicrosoftApp method. Maybe this will do what you want. On Mon, 25 Aug 2003 00:29:45 -0500, "Scott Holmes" wrote: Does VBA have a method for bringing the application window to the front? I can do it with the Windows API but I'm hoping for a simpler solution, like an "Activate" or "SetFocus". TIA -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bringing Excel to the front
For what it's worth, I solved the problem by minimizing the application that
was in front of Excel and that worked for this application. Thanks for the input! -- Scott Holmes "Dave Peterson" wrote in message ... This caused the excel icon on the taskbar to flash: Application.Wait Now + TimeSerial(0, 0, 5) AppActivate Application.Caption (the .wait gave me time to activate a different program.) Scott Holmes wrote: I saw that one, but there is no constant for Excel. Thanks anyway -- Scott Holmes Cornerstone Solutions, Inc. 713-661-5200 "Myrna Larson" wrote in message ... There's an ActivateMicrosoftApp method. Maybe this will do what you want. On Mon, 25 Aug 2003 00:29:45 -0500, "Scott Holmes" wrote: Does VBA have a method for bringing the application window to the front? I can do it with the Windows API but I'm hoping for a simpler solution, like an "Activate" or "SetFocus". TIA -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tables in excel- bringing down formulas for new records. | Excel Worksheet Functions | |||
Bringing Data From Access To Excel | Excel Worksheet Functions | |||
Problems with bringing in pictures from Excel to Word | Excel Discussion (Misc queries) | |||
Bringing in a Union Query with excel? | Excel Worksheet Functions | |||
Bringing Word doc into Excel | Excel Discussion (Misc queries) |