Pulling data from Internet Explorer in newly opened window

After reading your code, one idea I would have is to find the URL that the submit button you're clicking is going to. Read the HTML to find this. I've found that the Element Inspector provided with Google Chrome is excellent for this task. Then see if you can just create that URL yourself in the code and use .navigate with your current IE object to go to that page.

Then you can set your htmlcoll to that document and off you go.

Depending on the consistency of the URL, you may be able to do it right after you get the page after your log in without having to do the other loops. Might be faster.

Javascript, bummer. I've had problems with that too.

I recall one time being able to trap the interim URL that the Javascript launched. I'm assuming that your resulting window has a URL that is useless to you. That is if you try to launch it separately, it doesn't work for you.

I was able to trap the interim URL that flashes through the browser briefly by monitoring the LocationURL property of the IE object, and then used that URL in my code to circumvent the javascript.

Don't know if it'll work in your situation, but might be worth a try.

Does the IHTMLDocument2 property give you access to the document in the second popped-up browser window?

Excel_Geek:

I've been wondering about this problem and found a post in another context that I've adapted to this problem.

Below is a way to cycle through each open window. While doing that loop, you can test for anything, in this context, I've tested for the New URL that you might know your new window would have(??), and when found, grab that window's document. Once you've got that, you could continue on with whatever it is you need to do with that window's document.

Might work in your problem?

Please Login or Register  to view this content.