Get the LocationURL from the active Internet Explorter Window

Hello,

My ultimate goal is to get the LocationURL from the active Internet Explorer Window. I have been trying to use "GetObject("","InternetExplorer.Application"), but unfortunately this code will create a new Internet Explorer Window.

I have also consider using DDE, but I don't know enough about DDE to implement it.

Any information that you could provide to help me get the LocationURL from the active internet Explorer Windows would be greatly appreciated. Thanks for your time!

Sincerely,

TheRock

Take a look at this thread. gwdash shows an example of how to do this.