Excel VBA to Download CSV File from Internet

[Jacob1]

Hi all,

I want VBA to go to specific website, wait until the site has loaded, and click "Download Data". A CSV file is then dynamically generated and from there I can extract the data. All i need to know is how to get VBA to go to the website, wait until it has loaded, and click a specific button. How can this be accomplished?

Any assistance is greatly appreciated!