VBA To Determine if Window (IE) Is Minimized

[Filibuster]

Can anyone explain how I can use Excel VBA to determine the state (visible or minimized) of an Internet Explorer window?

I know the windows handle of the window I am interested in. I thought I could get the info using the API GetWindowInfo function - but have not been successful getting the function to work at all. I have very little experience using API functions. So, if GetWindowInfo is the way to go about it, please provide some sample code. If there is another/better way - I can go that route too. Thanks.

[Leith Ross]

Hello Filibuster,

To check if the window is visible, you need to use the API call GetWindowLong and test the Visible style bit (&H10000000). To check if the window is minimized to the task bar, you need to use the API IsIconic.

Here is some example code. Copy all this code to a separate VBA module in your project.

Please Login or Register  to view this content.

]

[Filibuster]

Thanks Leith - the code works beautifully. I'll apply to my application and see how it goes.

Since I started down the GetWindowInfo path (unsuccessfully), do you have any code that would demonstrate how to correctly use that API call? I get bothered when I cannot get something to work as I usually learn a lot by solving mysteries - even if I ultimately abondon the approach.

[Leith Ross]

Hello Filibuster,

You asked for it. I have included all the window style and window extended style constants for reference. You may want to use them for some later project.

Please Login or Register  to view this content.

[Filibuster]

Thanks Leith. This is excellent. I learned so much for both of your posts. I have incorporated your original post into my project and it is working great. Thanks again.

[Leith Ross]

Hello Filibuster,

You're welcome. Glad I could help.