Hi all,
I'm trying to create a currency converter that uses the data from the website of my country's national bank. The good thing is that they provide a direct .xls download of their latest exchange rates, meaning I have a link.

So what I want to do is have my macro automatically download that table to a preset location on my hard drive, open the file, copy the table to the active workbook, close the file and delete it.

Those seem like pretty simple operations but since I'm relatively new to VBA, I'll be glad if someone can provide me with some assistance.

Many thanks
Nick