I have a website that I use to pull data from including downloading Excel workbooks with the results I need.

The site requires a login as well entering numbers in which it returns values that I use in my Excel workbooks. Can VBA code be written to login, and enter predetermined values from a spreadsheet then download the results which I then use in my workbook?

If not, is there any software available that can operate websites that can be used in conjunction with Excel?