Hi all,

Quick question. I have an application link which checks to make sure a program is open, and if not, opens a new session. If the session is already open, Excel retains focus. If the session is not open, the application gains focus when opened, and I need to find the command to give focus back to Excel.

I've tried ActiveWorkbook.Activate (Activate being what I would use to call focus to the session object) but that didn't work, and a number of other tries have failed as well.

I definately do NOT want to use appActivate, as it's far too unreliable, requiring exact window naming which may change at any time.

The code I use to check for a session is below. 

Please Login or Register  to view this content.
Thanks for your help!

-Bob