Error when getting a web page from Access

[lance mcgonigal]

Hi...Thanks in advance for your help.

I'm trying to post a string to a website to log some data and I'm getting
the following error:

Run-Time Error '-2146697211 (800c0005)':
The system cannot locate the resource specified.

Here's the code:

Function GetPage(PageName)

Dim objSvrHTTP

Set objSvrHTTP = CreateObject("Msxml2.XMLHTTP.4.0")
objSvrHTTP.Open "GET", PageName, False

objSvrHTTP.send

GetPage = CInt(Replace(objSvrHTTP.responseText, "|", ""))

End Function

Environment:

Windows XP Home
Access 2007
References
VBA
Access 12 Object Library
ActiveX Data Object 2.1 library
Office 12 object library

Thanks again.

 

[Alex Dybenko]

Hi,
Look at this sample:
http://accessblog.net/2007/10/using-httpxml-to-get-data-from-web.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com