[AccessD] pull data from web page

JWColby jwcolby at colbyconsulting.com
Wed Dec 13 09:13:15 CST 2006


LOL, that'll teach me to ignore the threads on AccessD.  I just deleted all
the XML stuff that went by in the last few weeks.

I am using the MSXML object now to try and parse this thing.  Seems to be
working.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, December 13, 2006 9:37 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] pull data from web page

Hi John

This page may be of more help (it's European ...):

  http://www.ecb.int/stats/exchange/eurofxref/html/index.en.html

Base currency is Euro so will have to do a conversion for USD but that
should be easy for you.
Note the link for other pages with sources for XML etc.
XML here:

  http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml

If you find a nice method, please share.

/gustav

>>> Gustav at cactus.dk 13-12-2006 15:06 >>>
Hi John

They want $$$ for that service. 
Instructions here:

http://www.xe.com/dfs/ 

/gustav

>>> jwcolby at colbyconsulting.com 13-12-2006 14:56 >>>
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 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list