Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 155
  • Last Modified:

Logging the current sub's name....

Hi,

    I'm sure this comes up all the time. I would like to log errors / information and report the name of the sub / function from which they come. Is there any way to do this implicitely? Basically, I need a call which returns the current sub's name. Can it be done?

Cheers, Nik.
0
NikWhitfield
Asked:
NikWhitfield
1 Solution
 
wsh2Commented:
At run time.. only with Hard coding.. <sigh>.
0
 
tureCommented:
Nik,

There is no built-in functionality for this.

The way to do this is to declare a global variable and set its value at the beginning of each procedure.

Ture Magnusson
Karlstad, Sweden
0
 
ashunigamCommented:
Hi Nik
At the start of application open the log file using Open statement .

In each critical procedure<u want log>, use On Error goto ErrHandler

In err handler Use Print # method to log the error along with time etc:


'say number is 1 for LogFile
Exit Function
ErrHandler:
Print #1, Now & ": Function GetValue:" _
& Err.Descripotion

Hope it helps.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now