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

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

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

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