Fetching Exchange Rates
There is an Excel file that teaches how to perform the Fetching Exchange Rates operation.
Excel Format: Fetching Exchange Rates
This workbook fetches live exchange rate data using VBA and displays it in a five-row currency table.
Hope it is useful.