DWUTKA at marlow.com
DWUTKA at marlow.com
Wed Jan 28 15:36:20 CST 2004
You may be able to 'browse' to secured sites, with the following URL: http://username:password@www.website.com This works for sites that use plain text password security, if you are prompted for a domain, along with a name and password, then the URL 'format' above won't work, but IE can be setup to use your currently logged on credentials. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Erwin Craps - IT Helps Sent: Wednesday, January 28, 2004 2:53 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Getting internet data 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