[dba-VB] pull data from web page

Jim DeMarco Jdemarco at hudsonhealthplan.org
Wed Dec 13 08:06:09 CST 2006


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

I need to pull an exchange rate from a web page programmatically.  The
web page is:
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

dba-VB mailing list
dba-VB at databaseadvisors.com

More information about the dba-VB mailing list