Jim Lawrence
accessd at shaw.ca
Wed Dec 13 12:19:47 CST 2006
Hi John: You should look into 'screen scrapping'. It can be complex but a good place to start investigating would be: http://www.devcity.net/Articles/48/1/screen_scrape.aspx ...and the site where I got most of the information to use in a client project... http://simile.mit.edu/ (excellent site.) I have only this in passive mode but there is ways of invoking it in active mode. I will send a note off to my son-in-law who does know. Jim -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Wednesday, December 13, 2006 6:13 AM To: dba-vb at databaseadvisors.com Subject: Re: [dba-VB] pull data from web page I am looking around. Nothing found so far. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Jim DeMarco Sent: Wednesday, December 13, 2006 9:06 AM To: dba-vb at databaseadvisors.com Subject: Re: [dba-VB] pull data from web page John, Not sure about reading the HTML (which you can find code for on codehound or other code search) but I'd bet if you look around you can find a web service that you can query and return some XML which will be much more straightforward to parse (since a web page's HTML code could change and break your code). Jim DeMarco -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Wednesday, December 13, 2006 8:57 AM To: 'Access Developers discussion and problem solving'; VBA Subject: [dba-VB] pull data from web page Guys, I need to pull an exchange rate from a web page programmatically. The web page is: http://www.xe.com/ucc/convert.cgi And I need to feed in the data and pull the results out of the page. Is this possible? If not, does anyone know of an exchange rate calculator that has live data that is usable from inside of vba? John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com