Haslett, Andrew
andrew.haslett at ilc.gov.au
Wed Jan 28 17:57:58 CST 2004
Might want to check out this article. Looks like this feature will soon be removed: http://support.microsoft.com/?kbid=834489 -----Original Message----- From: DWUTKA at marlow.com [mailto:DWUTKA at marlow.com] Sent: Thursday, 29 January 2004 8:06 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Getting internet data 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com IMPORTANT - PLEASE READ ******************** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not.