I would like to get some advice on what Windows Automation software to purchase for my company. Preferably it should be something that can be purchased from a "real" company rather than shareware.
It has to be able to do the following:
1) Simulate a person interacting with a web form/application through Internet Explorer. Including entering data into fields, selecting from lists, and clicking on buttons.
2) Needs to have some sort of file that can store the data to enter into the fields. This way we can have it loop and interact with the web app over and over again with different inputs.
3) Needs to support cutting-and-pasting of web result pages into Excel or another application.
Basically we are trying to deal with a limited web front-end to a database. We would like to construct complex queries that return all the data we need in one-fell-swoop, but this is not allowed. So now we have to get the data bit by bit and paste it all together in Excel. This takes way too much time and is subject to user error.
So if we can "queue" all our queries in a file that is executed against the web form by some Windows automation software, then we get all the data by just pressing one button.