from Posts by Jake Marx

If you go to the VBE and select Tools | References, look for Microsoft
Internet Controls and check the box next to it. That will allow Excel to
use the necessary library for the code to work as written.

Sub test23()
Dim ie As InternetExplorer

Set ie = New InternetExplorer

ie.Navigate URL:="http://www.longhead.com/"

Do While ie.Busy Or Not ie.ReadyState = _
READYSTATE_COMPLETE
DoEvents
Loop

MsgBox ie.Document.body.innertext

ie.Quit
Set ie = Nothing
End Sub

--
Regards,
Tom Ogilvy

"nivek" wrote in message
...
Is it possible to open a new instance of internet explorer with a command
button and pass it an address from an text box in excel? If so, can
someone
please give an example of syntax?


TIA,
nivek