Obtaining an object name from a run time error 1

[barrysprout]

Does anyone know if there is any way to obtain the name of an object that causes an ‘object exists (3012)’ or ‘can’t find object (7878)’ run time error? I want to create an error handling routine that requires me to know the name of the object that is causing the error. Thanks.

 

[CautionMP]

barrysprout,
Have you tried the [tt]CodeContextObject[/tt]?

CMP

(GMT-07:00) Mountain Time (US & Canada)

 

[barrysprout]

Thanks CautionMP.

For anyone else interested, the following link addresses this exact issue:

http://msdn.microsoft.com/library/d...en-us/vbaac10/html/acproCodeContextObject.asp