Trapping errors

[Tony Williams]

How do write a piece of code that traps VBA error messages and ignores
them?
See my post on 22/07/07 about an Automation error message
Thanks
Tony

 

[Douglas J. Steele]

Take a look at what Allen Browne has at
http://www.allenbrowne.com/ser-23a.html

 

[RDunlap]

Use "On Error" and "Resume Next".

If you are wanting to ignore just a specific error, make sure you check for
that particular error number before just ignoring it.

The better solution would be to fix whatever is causing the original error
if possible.

 

[Tony Williams]

Thanks for that. The error is something to do with "Automation" which I
don't understand. It doesn't seem to affect the running of the database
though?
Cheers
Tony

 

[Tony Williams]

Thanks Douglas
Tony

Take a look at what Allen Browne has at
http://www.allenbrowne.com/ser-23a.html