Problem manipulating IE window (opens minimized)

Hey guys!

I have a macro that opens an IE window and then does some stuff with it via SendKeys commands.

Usually it works fine - the IE window pops up on top of Excel and is the active object, and then the macro does everything it needs to.

Sometimes the IE window opens minimized though, and then the Sendkeys commands start manipulating the Excel sheet and messes it all up.

Is there a way for the macro to check if the IE window is on top, and make it if it isn't, before executing the Sendkeys commands?

Thanks!

I recently had the same problem and found the answer here > http://www.mrexcel.com/forum/excel-q...rer-excel.html

mattmc419, to ensure that IE always opens up on a full screen mode. Paste the below on your module code for IE

Please Login or Register  to view this content.

Originally Posted by jayesh25

mattmc419, to ensure that IE always opens up on a full screen mode. Paste the below on your module code for IE

Please Login or Register  to view this content.

setting it to fullscreen however then causes the menus etc to be hidden.

use AppActivate Command before SendKeys

Hmm it's a better idea to actually use direct commands to send to a HTML doc referring to it's ID? I could probably share a more reliable solution to you if you tell us what you're trying to achieve by sharing the website link and what details you need to paste under which category that you're currently doing with SendKey?

Yeah usually I use the ID, but I'm trying to do some automating of uploads on Amazon and 1) for some reason setting a dropdown list via the ID doesn't create the "Browse" button to choose a file to upload,and 2) that "Browse" button doesn't let me inspect element to find its ID to click.

So I've just been using SendKeys to tab to the two fields lol

ahh fair enough. In that case you could use what hafiz suggested Here's the sample code

Please Login or Register  to view this content.