I often update an excel model with a web query every morning. I am
looking for a way to automate this procedure using VBA. I simply copy
a an array of data into an excel range.

Effectively I have to:

1) go to the website
2) use the websites drop down menus to pick html or CSV file
3) use the websites drop down menues to pick the report that I want
4) use drop down boxes to pick the date range that I want
5) press OK and the site will either download the data in a html table
or it will create a CSV file and prompt me with a windows File
Download prompt which gives me the option of opening it or saving it.
6) then I simply highlight the arrray of data I want and paste into a
range that never changes in an excel spreadsheet. For simplicity I
always use the same start date and only ever change the end date. The
result is an array that gets bigger every day as new data gets
updated. I simply paste this growing array over the previous days
data in the excel spread sheet.

Is it possible to automate this in an Excel spreadsheet using VBA?
Which option would be easier html table or CSV file?

Thanks

TS