VBA navigate to specific screen

[bensonsearch]

Hi All,

Im not sure if this can be done, but can vba "navigate" to a particular active running screen, I have about 8 different screens of a particular program that I want VBA to be able to go through and display the one I want.

I can not find ANYTHING on this.

 

[Tom Urtis]

What do you mean by "active running screen"? If an object (I am guessing a Window based on the word screen) is active then there's no need to navigate to it as it is already active. Are you running 8 different screens for one Excel workbook, or do you mean 8 different apps such as on your taskbar. Not clear what you are dealing with or asking about.

 

[bensonsearch]

Hi Tom,

As in 8 different apps as in taskbar

 

[Tom Urtis]

Just thinking out loud, as you may know, Alt+Tab will cycle though the task, and this VBA line would that too...

Application.SendKeys "%{TAB}"

...but then the active app is no longer Excel. What you might need is a pop-up menu of open tasks and then select one that way, which will involve API. Seemingly do-able but first it'd be useful to know if this is on the right track for what you were wanting.

 

[bensonsearch]

Hi Thanx for your reply Tom

It seems like its right but the problem is it may not always be the same order of screens (eg alt + tab a number of times). the application to navigate (if it helps) is citrix JDE.

inside this app there is many screens which can be used. the screens will be open but I dont know how to tell it go to THIS screen instead of THAT screen.

does that help?