G Guest May 24, 2007 #1 Using VBA in Excel, How can I grab the current address from an opem IE browser window?
N NickHK May 25, 2007 #2 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/rhaminisys/ddeinfo.html#DDEDownload Otherwise look into automation. NickHK
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/rhaminisys/ddeinfo.html#DDEDownload Otherwise look into automation. NickHK
