How do you get the IE object when you have the Window handle

[bobkuhn]

I'm trying to use Excel 2010 VBA to download tables from an Internet Explorer application. I've gotten to where the IE download manager pops up a window saying "Do you want to open or save xxxx from xxxx?" with the OPEN SAVE and CANCEL buttons. I haven't been able to get beyond this popup.

I think the solution is to examine the HTML of the window and use the usual IE object methods to click the button I want.

I can get the handle of the popup window but I don't know how to get the object for that window.

I used "PAT or JK's API SPY 5.1" to generate the following and to verify that it returns the correct handle.

    Dim ieframe As Long, framenotificationbar As Long, directuihwnd As Long, popup_handle as long
    ieframe = FindWindow("ieframe", vbNullString)
    framenotificationbar = FindWindowEx(ieframe, 0&, "frame notification bar", vbNullString)
    directuihwnd = FindWindowEx(framenotificationbar, 0&, "directuihwnd", vbNullString)
    popup_handle = directuihwnd

I'm also pretty sure that there are no child windows of the popup. The only solution I found (to handling the download manager popup) wanted to send mouse clicks to the child window OPEN.

I'm running IE 10.

Bob