[SOLVED] VBA To Get URL From Active Internet Explorer Window

I am a novice at VBA and am looking for some code that will allow me to extract the URL from the current active (last opened?) Internet Explorer window.

Assumptions to consider: 1) There may be mulitple IE windows open, I need the URL from the last one opened which in my case will be the current active IE window, 2) The active window will not have any tabs open - just a single window with one URL, 3) I may also have several Windows Explorer windows open which should be ignored, 4) if it helps, the stacking of all windows on my machine would be top: Excel application where the code will be, second: IE window which has the URL of interest, rest: Outlook, other IE, windows explorer, etc.

I have searched quite a bit, and found many code snippets that will get URLs for ALL open IE windows, but I have not seen anything that will get the URL from the active window. Any help would be greatly appreciated.

Perhaps some windows API would be of use here? e.g.

Please Login or Register  to view this content.

This gets you the handle to the active window