VBA interacting with new IE window

[Ice223]

I'm using the code below to open up ie and navigate to a website. However, when I navigate around to get to the data I need, a new window pops up with the results that I need to retrieve. How do I set the focus to the new window so I can interact with that?

Thanks.

Sub Update()
Set Ie = CreateObject("InternetExplorer.Application")
With Ie
.Visible = True
.Navigate "http://..."
Do Until .ReadyState = 4: DoEvents: Loop
Do While .Busy: DoEvents: Loop

.Navigate "javascript:doExport('exportdlg')"

'a new window has now popped up.
'need code here to work with it.

end sub

 

[Norie]

Tom

I've only just noticed this thread but could this perhaps be a job for the FindWindow function from the Windows API?

 

[Legacy 98055]

Hi Norie... Thought of that. If you look at the arguments that are passed in the function...

Private Function GetInstance(TimeOutInSeconds As Double, Optional URL As String, _
Optional LocationName As String, Optional WindowTitle As String, _
Optional Hwnd As Long) As InternetExplorer

WindowTitle and Hwnd would be used in secondary searches performed within the function if you are not able to determine the LocationURL. I only coded it for the location URL which would be sutiable the vast majority of the time. The code works as is. The OP just needs to spend a bit more time applying it. Thanks for the input.

 

[Norie]

Tom

Like I said just noticed the thread, haven't had time to digest and test everything that's been posted.

When I get a chance I'll do that, and perhaps post back though it looks like you've got things covered.

PS Totally agree about the URL thing - how can we test/troubleshoot without something to work with.