Bringing Excel to the front

  • Thread starter Thread starter Scott Holmes
  • Start date Start date
S

Scott Holmes

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
 
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 said:
I saw that one, but there is no constant for Excel. Thanks anyway
Click to expand...
 
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 said:
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.)
Click to expand...
 
Back
Top