Hi,

You can use the XMLHTTP object to read the HTML:

Public Function gsGetHTML(rsURL As String) As String
Dim x As Object

Set x = CreateObject("Microsoft.XMLHTTP")

With x
.Open "GET", rsURL
.send
Do Until .ReadyState = 4
DoEvents
Loop
gsGetHTML = .ResponseText
End With

Set x = Nothing
End Function

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]


wrote:
Hi all,
My function looks like:
Function getWebPage()
Dim loInet As InternetExplorer
Dim lsURL As String
Dim loObject As Object


Set loInet = New InternetExplorer
loInet.Visible = True

lsURL = "http://finance.yahoo.com/"

loInet.Navigate lsURL

End Function

I don't know how to read the HTML site I just opened.