Accessing Web site HTML

[Guest]

In Access 2000, I have tried using the MSFT Internet Transfer Control
(Inet1), and the Wininet dll to get the info from

http://finance.lycos.com/qc/stocks/quotes.aspx?symbols=NYSE:ADP+BHP

this web site.

Using either method I do not get the data between "Multiple quotes" and
"Latest News" That is the area I need to parse and pick out the data.

Any suggestions?

Thanks

 

[Ron Weiner]

Sheldon

Try using this code to return the page

Function GetFromWebpage(URL As String) As String
On Error GoTo Err_GetFromWebpage
Dim objWeb As Object
Set objWeb = CreateObject("Microsoft.XMLHTTP")
objWeb.Open "GET", URL, False
objWeb.Send
GetFromWebpage = objWeb.responseText
End_GetFromWebpage:
Set objWeb = Nothing
Exit Function
Err_GetFromWebpage:
GetFromWebpage = "Error"
MsgBox Err.Description & " (" & Err.Number & ")", vbExclamation,
"GetFromWebpage"
Resume End_GetFromWebpage
End Function

I am seeing everything between

<h1>Multiple quotes</h1>

and

</span><p class="none"></p></div><h3>Latest News</h3>

from the example you posted.

Ron W