A friend told me that he several times a week manually accessed Sveriges Riksbank’s website to download CSV files with exchange rates, and thereafter manually copy the data from the downloaded file into the Excel file he is currently working in. I decided to write him a VBA script that automates this work for him.

When running the script, a form opens in which he can choose which currencies he wants for which time interval etc. When he clicks “RUN”, the data is retrieved from Sveriges Riksbank and added as a new worksheet in a second.

If you want to try the tool yourself, I have uploaded it to my GitHub repository here.

VBA

VBA