Function to obtain currency exchange rates - How do I make it work?

**carlito2002wgn** · 03-12-2019, 10:34 PM

Hi, Sorry to ask what is probably such a simple question, but I am stumped!

I found the below function to get currency exchange rates, but I don't know how to make it work. I put it in the vbe just like I would a Sub procedure, but when I try to run it, it just brings up my macros window. I enabled the "Microsoft WinHTTP Services, version 5.1" reference as directed in the instructions, but that made no difference.

Here is the site where I found the function:
https://access-excel.tips/get-foreig...ate-excel-vba/

Here is the code:

Please Login or Register  to view this content.

All help is greatly appreciated!

**alansidman** · 03-12-2019, 10:57 PM

Here is a currency worksheet that I developed using Power Query. You will need to click on Refresh twice for the spreadsheet to update. You will need to make sure that you have Power Query installed.