I'm looking for a basic concept to test classes.

Ideally something equivalent to junit in java, so you can do unit regression
testing easily. I've tried vbLite, but had problems getting it's test runner
form to work in VBA.

Anyone have any favorite test standards or links to articles on the subject
they recommend?

TIA

You might need the functionallity of VB.NET. Do you absolutely need to
run this code in a macro? VB.NET uses

Try
...
Catch
...
Finally
...
End Try


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I would like it Claud, and without needing to go to vb.net.

What you've outlined is net's error handling mechanism, which is pretty much
how java does it. Much better than VBA does, but it's still not unit
testing.

Thanks anyway!

"Claud Balls" wrote in message
...
You might need the functionallity of VB.NET. Do you absolutely need to
run this code in a macro? VB.NET uses

Try
..
Catch
..
Finally
..
End Try


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Eric,

I'm looking for a basic concept to test classes.

Ideally something equivalent to junit in java, so you can do unit regression
testing easily. I've tried vbLite, but had problems getting it's test runner
form to work in VBA.

Anyone have any favorite test standards or links to articles on the subject
they recommend?

Unfortunately, I don't know of any automated/wrapper forms to simplify the
process. I find the best results are obtained by a manual inspection of the
code to test in order to identify some test data that will ensure all the logic
conditions are exercised, then write a wrapper routine to fire all the test
data at the class and check the results.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk