title: Automate downloads from password protected website
body: <p>I need some help with a work project I have been assigned. At the moment we manually go to the site, logon and then download 2 excel files from a supplier's website every month. The files are then loaded into SQL.  </p>
  
  <p>We want to automate this process. Now the loading of the files into SQL I can do, but I am not sure how I can automate logging onto the website entering my user details and collecting the files. I mostly deal with SQL and have very little .NET experience, so any code samples would be most appreciated.</p>
  
  <p>Just to confirm. The logon form is on a aspx page. just a basic form with a table containing the username &amp; password fields, the forgotten password link and the logon button </p>