Currency conversion

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

Hi,

The best way to learn is for you to turn on your macro recorder ...
and go through all your steps ...

You will then visualize how the whole process has been coded in VBA ...

HTH

Originally Posted by JeanRage

Hi,

The best way to learn is for you to turn on your macro recorder ...
and go through all your steps ...

You will then visualize how the whole process has been coded in VBA ...

HTH

Hm, I've been using it for quite a while but I thought downloading would require a bit more programming skill. Turns out it doesn't, at least not for this simple task. Thanks, using the recorder worked great!