Hi! I'm new to Excel VBA and have a question to you
I would like to automatically download an individually fitted table from Eurostat with Excel.
The problem is that first I have to go to the following page:
http://epp.eurostat.ec.europa.eu/por.../data/database
=> choose the desired database
Now I have to do some changes => Countries, Time, etc.
After that I'd like to download the file. (=> click on download => choose full extraction => download in Excel format)
The modifications are ALWAYS the same (exception: 1 additional month for the time). It would be good to do everything straight from Excel (I would like to update the file once a month, meaning on every 1st of the month pressing a button in Excel)
I already know how to do it when the link is given, it works like that:
Private Sub CommandButton2_Click()
Application.DisplayAlerts = False
With Workbooks.Open("https://www.destatis.de/DE/Publikationen/Thematisch/Preise/Erzeugerpreise/ErzeugerpreiseLangeReihenXLS_5612401.xls?__blob=publicationFile")
.SaveAs "F:\yourfile.xls"
.Close
End With
End Sub
But that doesn't help me in my case, as Eurostat is not giving the data like Statistics Germany.
Could somebody please help me?
Greetings.
Bookmarks