VBA Macro Help

[slh15]

I am trying to create a macro where I export data from a website. So far I have coded the macro to open internet explorer, pull up the website, and log in for me. My next steps need the macro to click the 'Plan' tab which provides a drop down where I will then need to click 'Reports". Once there, I need to click the 'Late' option, Search, and then once loaded, Export. Does anyone know how I could code this/if it is possible? I am having a hard time figuring out how to have the macro "click" multiple buttons

 

[NigelBarrett]

For that I would use UIPath RPA software. There is a Community version that is free to use. It will be a bit of a learning curve but it is very powerful - saved us a lot of money in the long run.
Another option could you link Power Query to backend somehow and download the data that way?