Open webpage & click download button

Hi,
On the face, this seems like a trivial thing, but I tried searching the Internet in vain.

There is a public website. I want VBA to open the webpage and (simulate) click the download button, so that I can then programmatically access the csv file that gets downloaded. I found this code on the Internet, but unfortunately the website does not load properly in IE.

If I try the Chrome object, it gives me an error - "ActiveX component can't create object" (Is something missing in Preferences?)

Please Login or Register  to view this content.

Also, how do I go about accessing the download button? Here is the location of the download button I got from Inspect.

Please Login or Register  to view this content.

I was able to navigate to the web page in Chrome by installing Selenium and using the Chrome driver for Selenium.

However, I am struggling to narrow down to the download element. Hoping I will be able to progress once I find some more Selenium methods.

I am not sure on how to get VBA to interact with a web page ,but if the export is in the same spot every time how about using VBA to mouse click

Please Login or Register  to view this content.

Originally Posted by aworfolk

I am not sure on how to get VBA to interact with a web page ,but if the export is in the same spot every time how about using VBA to mouse click

Please Login or Register  to view this content.

This is cool, thanks. I will make a note of it.

However, I was able to find the element and click on it through the Selenium code in VBA. But I ran into another problem that it opens a login prompt. If I am already logged in, it doesnt work as this session of Chrome is different (because its controlled by VBA I guess).