Hi everyone!

This may be more appropriate in the programming section but I figured I'd check here first!

What I want to do may be abit complicated but hopefully it's something possible to do!


I have a system filled with diffrent information on for example people or agents at a call center, amount of sold food at a restuarant or something like that. The system requires a login and before pressing login there is a checkbox that has to be checked before logging in. Then when you log in a new window opens and here there are many subcategories to choose from (Also in these subcategories there are some drop lists and checkboxes to push to get the correct info) and then at the bottom after the information has been loaded a button to get an excel file from this information.

What I want is a button in excel that I can push that will automatically log on the website, click the subcategory of my choice and the options needed and then grab the excel file. Once the file is downloaded I want it to open it and copy the information in it to a sheet in my workbook.

Is this possible in any way?

I want to do this to be able to grab statistics easy and not have to do it manually. Once the information is in my sheet I think I know how to get the infromation setup in the way I want it!

So is this possible at all or should I just give up on this dream?