Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
error trap/handler placement
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="SteveDB1, post: 6349587"] morning all. a colleague and I are expanding our macros to start including a specific error trap or handler so we can move files to a lateral directory, and deal with them after we're done processing all of our files-- around 5000 files in all. One of the things that I've noticed about previous macros that some of you have helped with is that with the application.inputboxes an error trap is placed. I.e., if I had 5 input boxes, there would be 5 error traps. So, my questions are about the placement of error traps, or error handling statements: Is it best/wisest to place an error trap/handler (and if I'm saying this wrong, please forgive me, I'm still vague on sematics with this kind of thing) at every location where it's plausible that an error will occur? Or, can we place a single error handler within a macro, and if an error occurs, it calls to our lateral transfer macro? Thank you. Best, SteveB. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
error trap/handler placement
Top