VBA - How to Login to a Website and get CSV file

This is code that I used to login to a site and download a file. The name of the objects and data fields need to be found - use "Examine code" on the page where you login.... It may be complicated by needing to automate clicking the save button in a pop up window.

You could also talk to your IT department and have them run a script that copies the file into a folder every day, where you can just grab it.

Please Login or Register  to view this content.