Jim DeMarco
Jdemarco at hudsonhealthplan.org
Wed Dec 13 08:06:09 CST 2006
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