Best Windows Automation Software

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.

Any ideas/recommendations?
LVL 2
dastrwAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DexstarCommented:
@dastrw:

> 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.

I don't know how handy you are with Excel, but Excel can directly open web pages and import their contents.  It also has a huge macro interface that you could use to automate the process.  Maybe put all the parameters for your queries in one sheet, and then have a macro that opens up each query and saves the data.  Just a thought.

Hope That Helps,
Dex*
0
dastrwAuthor Commented:
How do I get Excel to enter data from the spreadsheet into web form fields?  And how do I get Excel to click on the web form's "Submit" button?
0
DexstarCommented:
Okay, well, if that's the case, then it might be easier to write a macro to automate Internet Explorer.  What you want to do is entirely possible, I'm just not sure how much effort you want to put into it.  It isn't going to be something you just whip out in a few hours.

Dex*
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

dastrwAuthor Commented:
That's the point of Windows Automation software (e.g. WinBatch).  It basically lets you record macros within the entire Windows system rather than just in Excel or just in IE.  I have extensive experience writing VB macros in Excel and Access, but I don't want to have to write that odd Microsoft code to call out of one application into another and worry about handles, etc.  I'd like something that lets me write understandable code that spans all of the applications in Windows.

WinBatch claims to do this, but their web page hasn't been updated in over a year and I'd like to get some ideas on other products before settling for this one.
0
DexstarCommented:
Okay... Well, I asked around, and my one friend swears by http://www.unisyn.com/automate/  but my other friend tells me that http://www.pitrinec.com/toolsworks.htm is the way to go.  So, check those out.

Dex*
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dastrwAuthor Commented:
I had found those two as well on an earlier search.  It is good to hear that others think well of them.

Has anyone you know used them for what we're looking to do?  Most of the user testimonials talk about automating sys admin tasks and similar.  I don't see where people are using them to simulate web application execution.
0
DexstarCommented:
Yeah, the guy who uses AutoMate does stuff with the Web and Word, which is similiar to your Web/Excel application.

Dex*
0
dastrwAuthor Commented:
Thanks for your help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows 2000

From novice to tech pro — start learning today.