LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 414
Default error trap/handler placement

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error Handler sharad Excel Discussion (Misc queries) 1 September 17th 07 06:38 PM
VBA Error Handler MVM Excel Programming 1 June 12th 06 07:56 PM
Error Handling - On Error GoTo doesn't trap error successfully David Excel Programming 9 February 16th 06 05:59 PM
Form Err.Raise error not trapped by entry procedure error handler [email protected] Excel Programming 1 February 8th 06 10:19 AM
error handler Fleur Excel Programming 1 November 20th 03 06:06 AM


All times are GMT +1. The time now is 05:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"