Auto update of exchange rates

[mounty76]

Hi All,

I've seen quite a few threads on here about updating exchange rates automatically every 10 minutes from a hidden form whilst DB is open. I'm pretty lost with it to be honest is complex VBA, any help much appreciated how I could do it with the attached DB, I only need the currency exchange rates updating for the currencies in the table, but note that I may have to add new currencies then at which point the update would have to update them exchange rates also.

Any ideas most welcome!!

 

[Gasman]

If you are going to make extensive use of it, this would save you a lot of time for a reasonable cost, plus I expect you could learn a lot from the code.

Currency Exchange Rate Tracker

Purchase Currency Exchange Rate Tracker (Source Code)

www.isladogs.co.uk

 

[Gasman]

I also had a Google

Get exchange rates from a certain date with Excel VBA

I would like to create an Excel function that can get the exchange rate between two given currencies at a given date. Something like: =GetFX("USD","GBP","31/12/2020") I

stackoverflow.com

 

[SusieEdwards]

Thanks for answering, I appreciate your time.