I have a fairly large Excel add-in that revolves around a GUI composed of a few UserForms, with standard VBA controls (listboxes, text boxes, radio buttons, command buttons etc.). It's a large enough project that testing it by hand is becoming unmanageable, so I am looking to automate parts of the testing process.
The main problem is that most of the automated testing tools I have looked into (Rational Robot, AutomatedQA TestComplete, etc) don't support the VBA controls so their tests are effectively just replaying mouse clicks and key presses, so aren't really maintainable. Network Automation's Automate 6 did a reasonable job of recognising and manipulating the controls but had the odd glitch (it didn't like dealing with radio buttons, for instance).
I also considered building the test automation into the add-in, but most of the user's time is spent interacting with a modal dialog which stops the automation script running in the background, so that's pretty much out of the question.
My question- does anyone here have any experience with an automated testing tool that
a) recognises VBA user form controls and can reliably interact with them
b) has support for test scripting with conditional branches and success/failure logging, rather than just record and playback
?
I've spent a while looking around QA forums but haven't found much there, so any help or leads would be appreciated.
Thanks for your help,
- Martin
The main problem is that most of the automated testing tools I have looked into (Rational Robot, AutomatedQA TestComplete, etc) don't support the VBA controls so their tests are effectively just replaying mouse clicks and key presses, so aren't really maintainable. Network Automation's Automate 6 did a reasonable job of recognising and manipulating the controls but had the odd glitch (it didn't like dealing with radio buttons, for instance).
I also considered building the test automation into the add-in, but most of the user's time is spent interacting with a modal dialog which stops the automation script running in the background, so that's pretty much out of the question.
My question- does anyone here have any experience with an automated testing tool that
a) recognises VBA user form controls and can reliably interact with them
b) has support for test scripting with conditional branches and success/failure logging, rather than just record and playback
?
I've spent a while looking around QA forums but haven't found much there, so any help or leads would be appreciated.
Thanks for your help,
- Martin
