Exchange Rates and Currency Conversion in VBA
When converting amounts between different currencies, you need exchange rates. This article demonstrates how to obtain these from no less than nine different sources, either for free or - for intense or demanding use - for a fee.
Exchange Rates and Currency Conversion in VBA
Code is also on GitHub:
VBA.CurrencyExchange
Note, that web scraping is also demonstrated (The Central Bank of the Russian Federation), and the XE service is been included, though only a seven-day trial is for free usage.