I am extracting information from a website. This would be completed regularly and automatically. But I have hit a wall.

Using a webbrowser I have opened the website and logged on. Problems start when I click on a hyperlink which opens an excel file. Two windows messages appear.

1)How can I deal with the window which says "do you want to open or save this file"(I'd like to save it)

2)The file which opens is a .xls file which brings up another window ".........is in a different format than that specified by the file extension Do you want to open the file now?"

Can I deal with these messages during runtime. I realise sendkeys might be an option but wondered if there was another possibility.