View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bony Pony[_2_] Bony Pony[_2_] is offline
external usenet poster
 
Posts: 71
Default 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