unit testing advice

[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?

TIA

 

[Claud Balls]

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

 

[Eric]

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!

 

[Stephen Bullen]

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