Using VBA to log into a website and download a csv file that appears when chosing timeline

Hello dear friends and excel experts.

I have a problem that I would like to solve using your expertise.

I need to download some data from a website using VBA. I know how this can be done, but the process to get the csv file is quite complex.

1. I have to enter a website.
2. Then use username and password to login.
3. Then go to the statistics site.
4. Chose a timeline, say 2010-2020. This is done by first chosing 2010 from a "from date" dropdown and then chosing 2020 from a "to date" dropdown.
5. After chosing the from and to date, an excel file will appear with the correct data.
6. By pressing on the excel file you will automatically download an excel file.
7. The data must be used in an excel file where I analyze the data.

Is this possible? Is it possible to be guided on how to achieve the goal? Will this be easier to do using Power BI?

A appreciate any kind of help.

Best regards.
RR

I've had some success using Selenium for automating Chrome as it seems to be more reliable than IE.
You need to download an install it on the machine in question, then put a reference to it in the project.

Download from https://github.com/florentbr/SeleniumBasic/releases
After installing Selenium, you need to change the chrome driver in the root directory to an updated one. You can download it from here. https://sites.google.com/a/chromium....iver/downloads

You then need to analyse the website using developer tools and identify the elements you need to interact with.

Some example code to login to a website and download a file.

Please Login or Register  to view this content.