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