Error Handling overview

M

martylee54

Howdy All,

This has to be a perennial favorite; is there a good
overview of "best practices" for error handling in VB or
VBA? I've read a couple "white papers" on the internet,
but in general these seem to be advertisements for the
features of proprietary error handlers. (Not that there
is a problem with proprietary handlers per se, but I would
prefer a less biased source of information). Also, I've
downloaded the freeware code for HuntErr (from Urfin Jus),
which is at least much more sophisticated than my own
efforts. But it would be great to see what others have
adopted as standard practice.
 
W

Word Heretic

G'day "(e-mail address removed)" <[email protected]>,

rule 1 - avoid errors where possible through better logic flow
rule 2 - always turn it off ASAP
rule 3 - always clear a handled err
rule 4 - handle all known errs, and pass all others back to the UI.
rule 5 - batch mode needs to be more error friendly - handle all
errors close to the UI.


Howdy All,

This has to be a perennial favorite; is there a good
overview of "best practices" for error handling in VB or
VBA? I've read a couple "white papers" on the internet,
but in general these seem to be advertisements for the
features of proprietary error handlers. (Not that there
is a problem with proprietary handlers per se, but I would
prefer a less biased source of information). Also, I've
downloaded the freeware code for HuntErr (from Urfin Jus),
which is at least much more sophisticated than my own
efforts. But it would be great to see what others have
adopted as standard practice.

Steve Hudson

Word Heretic, Sydney, Australia
Tricky stuff with Word or words for you.
wordheretic.com

Replies offlist may require payment.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top