Hi,
In my opinion using web query will be easier, instead of downloading xls file. You can import data from the web-page.
Based on the information that you are in Berlin, I assume you are using ECB rates and they also provide xml file. So you can use something like this macro:
Sub ImportXML()
Application.ScreenUpdating = False
ActiveWorkbook.XmlImport URL:= _
"http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml", ImportMap:= _
Nothing, Overwrite:=True, Destination:=Range("$A$1")
Application.ScreenUpdating = True
End Sub
The macro above is very basic and you can changed it to fit your needs better.
Buran
Bookmarks