Exchange Rate/ currency conversion

[arnelgp]

this is a simple program that will convert 1 US dollar to any currency.
it gets the data from http://www.floatrates.com/daily/usd.xml.

the old method (Internet Explorer application) will not work on Win 10/11.
therefore this db is modified to use XMLDocument to get the data.

there are two subs (GetRates and GetNewRates), that does exactly the
same thing.
the only difference is that GetNewRates uses XML parsing rather than
manual scraping (GetRates).

modify to suit your need for other Base currency of your choice.

 

[Gasman]

this is a simple program that will convert 1 US dollar to any currency.
it gets the data from http://www.floatrates.com/daily/usd.xml.

the old method (Internet Explorer application) will not work on Win 10/11.
therefore this db is modified to use XMLDocument to get the data.

there are two subs (GetRates and GetNewRates), that does exactly the
same thing.
the only difference is that GetNewRates uses XML parsing rather than
manual scraping (GetRates).

modify to suit your need for other Base currency of your choice.

Anyone able to convert down to 2007 please?, I'd like to look at this.?
TIA

 

[Solo712]

Good work, arnel. I made two small adds: 1) a form to get the exchange on any two currencies using USD as reference. 2) a column in the table that converts the date string for updates for sorting on dates.

 

[Gasman]

Any chance on a 2007 version please?

 

[arnelgp]

i have not modified it yet in A2007.
for those with newer than A2007, here is another updated db.
you can now Select the Base Currency to use (other than USD).

 

[Gasman]

@arnelgp
Just a version that 2007 can open please arnel.
I have just downloaded your continuous form colour control example and that opens fine?

 

[mounty76]

i have not modified it yet in A2007.
for those with newer than A2007, here is another updated db.
you can now Select the Base Currency to use (other than USD).

Hi Arnelgp,

This is great however I'm struggling to understand the code, any advise greatly appreciated. I'm using a very simple table (attached) that I'd like the exchange rates updating every 10 min using a hidden form as you mentioned in an earlier post.

If I add more exchange rates then I'd want these updating too, even better would be if the exchange rate could be references to the home currency selected in the table?

I'm completely lost on this so any help is greatly appreciated!

Thank you