[AccessD] Getting internet data

Something like this may work

Sub test()
'set reference to MS xml 3 or 4
Dim xmlhttp As MSXML2.XMLHTTP40

Set xmlhttp = New MSXML2.XMLHTTP40
'xmlhttp.Open "POST", 
"http://moneycentral.msn.com/investor/research/printrep.asp?Symbol=MSFT", 
False
'where uid and pwd are userid and password strings
'if this doesnt work the userid may have to be passed in the headers
xmlhttp.Open "GET", 
"http://moneycentral.msn.com/scripts/webquote.dll?iPage=qd&Symbol=MSFT", 
False,uid.pwd
xmlhttp.send
'xmlhttp.Open "POST", strURL, False
'xmlhttp.send (sString)

Debug.Print xmlhttp.responseText
'then parse responseText string
End Sub

Erwin Craps - IT Helps wrote:

>I done that before (and still using it) with a HTTP control from IP
>Works (I believe they changed name into something else).
>You can get the page in a string and analyse it further.
>I believe there is a basic control from MS also in Access or VB, a HTTP
>control.
>
>Only one thing I don't know and is the tricky part... The password.
>No experiance in that one. But you should look at a HTTP control.
>
>I have my first code done with the XML parser. There is a HTTP XML
>parser to, maybe this can do the trick to.
>
>Erwin
> 
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby
>Sent: Wednesday, January 28, 2004 8:03 PM
>To: AccessD
>Subject: [AccessD] Getting internet data
>
>I need to get some internet data into a db.  In order to do that I need
>to "navigate", specifically I have to enter a username / password which
>will bring me to a specific page.  After that clicking on tabs at the
>top take me to other pages I'd also like to get data off of.
>
>Does anyone know how to do this from VBA?
>
>John W. Colby
>www.ColbyConsulting.com
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada