Network error
 

Does nayone know how to trap a Windows Error
the error message contains this

Network I/O Error

I want to trap this error but the regular error handler
does not work.

Is there a way to trap System or Window Errors when they
occur.
thanks Sirron

Network error
 

Hi Sirron,

What VBA code are you executing when you get this error? I think that's a
Jet error. Anyway, some context to your problem would be helpful.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


lin wrote:
Does nayone know how to trap a Windows Error
the error message contains this

Network I/O Error

I want to trap this error but the regular error handler
does not work.

Is there a way to trap System or Window Errors when they
occur.
thanks Sirron

Network error
 

How about:

On Error Resume Next


code which causes error
select case err.number
case 111
do whatever
etc

Angus


"lin" wrote in message
...
Does nayone know how to trap a Windows Error
the error message contains this

Network I/O Error

I want to trap this error but the regular error handler
does not work.

Is there a way to trap System or Window Errors when they
occur.
thanks Sirron