Loop Through Active Windows and Activate

Hi,

Can anyone help me with some code to loop through all my open window captions and if one matches "Session" then activate it and Bring the window into focus.

I tried AppActivate with the name "Session A" Which sort of works but only if the user has the name "Session A". I found some users have Session B Open instead and any other letter as well the only thing in common is "Session"

I also found something else odd that it appears at times to Activate the window but wont Bring the window into Focus or show the window.

Can anyone offer any suggestions?

Thanks, Mike

I assume you mean the window caption containing 'session' rather than being 'session'?

I just gave that code yesterday in another thread:

Please Login or Register  to view this content.

I'd probably use WinAPI for that (don't have code to hand as I'm on a Mac) but you could adapt snb's code to do what you need, assuming you can loop through the tasks collection and check the name.

I don't know if you've noticed, but you're unlikely to ever find shorter code than snb posts, if that's your main criterion.

Can't test at the moment, but are you sure you have the case of your window title correct? Like is case sensitive.

to get an overview:

Please Login or Register  to view this content.

You could try different things to get what you want (I can't see how 'unactive' this session is)

Please Login or Register  to view this content.

Once Again snb leads the way with the shortest working code.

@ romperstomper
You were right after running the first part of snb code I got a list of windows. Session A had this added onto the end -[24x80] so maybe that is why it wasn't working correctly, not sure.

@ snb

After playing around with your last code, I was able to get this below to work. I only removed the second with statement as it crashed on those lines. When you first posted your code I was confused (like normal) by the Word.Application part. I thought it was trying to activate a MS Word document which I wasn't working with.

But anyway here is what I'm using and it appears to be working just fine.

Please Login or Register  to view this content.

Thank You So Much for the help !!!! Again...

Mike

FWIW, an API version would be something like this:

Please Login or Register  to view this content.

As you may be well aware of, the development teams of MS do not communicate too often.
So it happens that some 'system' properties (like open applications) or the screenproperties (horizontally & vertically) have been built into the Word-VBA-library and not into the Excel VBA library.

For who is interested:

Please Login or Register  to view this content.

It's a simple method to adapt e.g. a userform to the user's screen screenresolution.