Module / procedure name detection
Thanks,
Didn't answer the question though.
Regards,
Bony
"Jacob Skaria" wrote:
Did you try writing a separate procedure say WriteLog() to record the
activity to
an external file or a hidden worksheet and call that from end of each proc..
If this post helps click Yes
---------------
Jacob Skaria
"Bony Pony" wrote:
Hi all helpful people!
Is there a way to pass the executing procedure name to a variable? I want
to keep a log of the most frequently executed procedures in a workbook so
each time a proc executes, I build a little table with the Module name,
procedure name, user and procedure duration (timed seperately).
All ideas treated equally!!
Best regards and happy Spring to the North!
Bony
|