jack drawbridge
jackandpat.d at gmail.com
Wed Jun 27 07:19:31 CDT 2012
Darren, I got the code from UtterAccess and have not done much with it. I did find another site http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml (European Central Bank) that was referenced in some materials and provides a list of currencies and the latest Euro relationship. However, I think Gustav's link is the "official site". I am interested in learning how to get material from the website using vba. If anyone has good examples or tutorial for same or use of XMLHTTP , DOM etc with vba, please provide coordinates. Darren I thought you were familiar with the processes involved and just needed some base code to work with. Like many things, I find a few "procedures/routines" and save them for when I have more time(ha ha). Thanks Gustav for the site info. Jack On Wed, Jun 27, 2012 at 4:39 AM, Gustav Brock <gustav at cactus.dk> wrote: > Hi Darren et al > > Also note that the EU has this official site, InforEuro: > > > http://ec.europa.eu/budget/contracts_grants/info_contracts/inforeuro/inforeuro_en.cfm > > with monthly exchange rates from the European Central Bank all the way > back from 1994 to the current month between Euro and just about any > currency. > > Data can be viewed on-line or downloaded in XML (though named as XLS > files) or CSV format. > > As rates are with six significant digits, you can create a triangular > conversion between any two currencies with a decent precision. > > /gustav > > > >>> darren at activebilling.com.au 27-06-12 1:47 >>> > Hi Team, > > A couple of years ago I read an article that had some sample VBA code on > how > to make contact with a webservice and retrieve currency conversions. > > I wrote a nice little interface to it in Access and all was well with the > world. > > I have a need for this little app but can't, for the life of me, find it > anywhere. > > Anyone know of any code etc. that might help me re-build this thingy? > > Many thanks in advance > > Darren > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >