Read / Access the function call list

[kelele]

I am building a global Error_handler() function. The function is called in any procedure where an error occurs. How can I tell which module/ procedure called the Error_handler() function from within the Error_handler() by reading the function call list. I am trying to avoid having to pass parameters such as the module/procedure to the Error_handler().

Thanks

Kelele

 

[Aivars]

Hi, Kelele!

I created function with parameter for error messages title in my applications like following:

call Error_handler(...., _
me.name & " ProcedureNameWhatCalledError)

Public Function Error_handler(..., Optional strErrMsgTitle as String="Error...&quot
.......
msgbox "Error message text", vbExclamation, strErrMsgTitle
.......
end function

Aivars

 

[jlitondo]

Kelele, are you from kenya by any chance? Shoot me an email if so. jlitondo@gatecitysteel.com