Andrew,
Sounds like Automating IE would be better:
http://www.microsoft.com/mind/0898/dom.asp
http://www.mvps.org/access/modules/mdl0062.htm

NickHK

"Andrew" wrote in message
...
Hi,

With help from this site I am able to open a url based on code but now I
want to update the same window (ie not open another windows) of IE. How
do I
do that?


Sub xx()
ThisWorkbook.FollowHyperlink _
Address:="http://finance.yahoo.com/"
Cancel = True
End Sub

Now I want to go to http://help.yahoo.com/help/fin/

I know I could go to the second page in one step but this is just getting
the basics for some more complex coding after I get the basics.
--
Andrew