View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scott Holmes Scott Holmes is offline
external usenet poster
 
Posts: 2
Default 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