LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default Handling different Error 1004 errors

Phil,

the short answer is no.

but in your own example, you know when you get the error at that line, that
the file was not found. So you can anticipate for each particular line of
code what error could occur and you adjust your error handling at each point
to respond accordingly.

Perhaps not what you wanted to hear, but it is pretty much common practice
to proceed the way I have described. I don't think I have ever seen code
where the error description string is parsed to determine the nature of the
error.

--
Regards,
Tom Ogilvy


"Phil Hibbs" wrote:

joel wrote:
the error methos has a number of properties


....and the Description property is the only one that contains more
info about the nature of the error.

Phil Hibbs.
.

 
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
handling #Div/0! errors rockhammer Excel Programming 3 July 28th 08 06:09 AM
Error handling error # 1004 Run-time error [email protected] Excel Programming 3 May 20th 08 02:23 PM
VB handling on mdi print error code 1004 Walter L. skinner Excel Programming 1 October 5th 05 03:30 PM
Handling Errors and MessageBox Joel Mills Excel Programming 4 June 2nd 05 05:53 PM
Handling errors in formulas (how annoying are they!) anon90210 Excel Discussion (Misc queries) 1 January 17th 05 01:26 PM


All times are GMT +1. The time now is 06:16 PM.

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"