Excel macro and the Download dialog box in IE11

[Tulon]

Back in IE8, when you tried to download a file, it'd pop up a little box asking if you wanted to download or save the file. Macros in Excel could work through it using code like 'hWnd = FindWindow("#32770", "File Download")' to get the box and interact with it.

IE11 now has an obnoxious little ribbon that appears at the bottom of the window instead of the box, so FindWindow comes up blank.

There are a number of files including .xls, xlsx, and .csv, and there isn't a static link directly to the files, so I can't just put the link in workbooks.open. Also, to get some of the files, there are logins and forms to fill in with dates and the like. I can get through all of that stuff and click the button to download, but it's that open/close button that's stumped me.

Anyone have a way to get an Excel macro to interact with that Open/Save ribbon in IE11?

 

[Tulon]

I know people have been looking for this for a while and the only answer that seems to come up doesn't work on anything past IE8, but it looks like 'hWnd = FindWindowEx(IE.hWnd, 0, "Frame Notification Bar", vbNullString)' may get you that stupid Open/Save ribbon they switched to in IE9 and above.