[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