George,
The simplest way (VB5/6) is to use DDE, possibly the only time I have used
it:
http://vbnet.mvps.org/code/internet/browserurl.htm

Not sure if recent updates will prevent this.

However, VBA does not support DDE from its native controls, but you can from
a cell. Never tried it though like this.
This site has a DEE client control that you may be able to use:
http://www.angelfire.com/biz/rhamini...ml#DDEDownload

Otherwise look into automation.

NickHK

"George Heimovics" wrote in
message ...
Using VBA in Excel, How can I grab the current address from an opem IE
browser window?