Solved

Getting the calling function NAME at run time

Posted on 1998-06-04
10
358 Views
Last Modified: 2010-05-03
Hi,

I have a situation like this: I have some function, and when it starts I want to know which function called it.

For example, I have these functions F1() and F2() that call F3(). When I start F3 from F1 I want to get a message box
that says "Function F1() called me".

How can I do that? And I don't mean solutions like keeping a global string and fill the name of the current function whenever it starts. I want it to happen automatically!

Is it possible?
0
Comment
Question by:yronnen
  • 2
  • 2
  • 2
  • +4
10 Comments
 
LVL 6

Expert Comment

by:clifABB
ID: 1462517
No.
0
 
LVL 1

Expert Comment

by:sirigere
ID: 1462518
I think this might solve the problem
In the Global module declare
Global FunctionCalled as string
sub f1()
msgbox functioncalled
functioncalled="function F1"
f2
end sub
sub f2()
msgbox functioncalled
functioncalled="function F2"
f3
end sub
sub f3()
msgbox functioncalled
functioncalled="function f3"
f2
end sub
sub main
functioncalled=""
f1
end sub
0
 
LVL 5

Expert Comment

by:bin_huwairib
ID: 1462519
I don't think this is possible in VB,  yronnen.
Beside you are loosing nothing when you use a global variable.

8) Bin Huwairib

0
Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
LVL 5

Author Comment

by:yronnen
ID: 1462520
What I mean is that I want it to be done automatically!
I don't want to go to each function and add a line with its name.
0
 
LVL 1

Expert Comment

by:sirigere
ID: 1462521
To yronnen
Can i see the part of code where you are facing this problem?
0
 
LVL 1

Expert Comment

by:raygibbins
ID: 1462522
The global variable woudn't work, because depending on where you are in the program, other functions could also be setting this variable at the same time.
You would have to pass the FunctionName as a string to ensure that the called function knows who called it.

Paste this into a form, and Click it

Function CalledFunction(ByVal CallerFunctionName As String)
    MsgBox CallerFunctionName & " Called Me"
End Function
Private Sub Form_Click()
    CalledFunction "Form_Click"
End Sub

0
 
LVL 5

Author Comment

by:yronnen
ID: 1462523
You don't understand what I mean. I DO NOT want to go to every function that calls F3() and call it using their names. I want to get their names automatically.
0
 
LVL 18

Expert Comment

by:deighton
ID: 1462524
yronnen

I understand what you mean, but I don't know of any way to do it - but why do you want to do this?  What is the actual predicament you are facing ?

raygibbins,

Is that right?  That would mean VB was running more than one bit of code at once - I didn't think it could suddenly fly off to another routine unless there was a DoEvents - I never thought of this I'm scared.


0
 
LVL 3

Expert Comment

by:rmichels
ID: 1462525
FailSafe from NuMega can help you manage this problem, but...it does automatically add lines to each function to track the calling sequence.  Not what you want, but it does automate the process.

Also, under VB5 you can compile with symbols. Not sure it you can easily get to these symbols at run time (I think PSAPI.DLL under WIN32 has support to get this debug information)...but normally you would not ship a program with symbolic debug on.
0
 
LVL 6

Accepted Solution

by:
clifABB earned 100 total points
ID: 1462526
Based on comments subsequent to my short comment.  You can rest assured that it cannot be done.  Even the best profilers will place code in each module so that it can keep track of which modules are called from where.

Therefore, I feel confident that I can submit this as an answer.

"It is not possible."
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question