View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default variable or propertie 'name' for self written sub or function

Ah, the good old days! I was on Tandem's before TACL, and really appreciated
it when it was introduced.

Bob



"Chip Pearson" wrote in message
...
You're an old Tandem/NSK man, Bob. We could do this in TACL. What was it,
#ROUTINENAME? Something like that. And in TAL, not only could you read the
Call Stack to see who called the current procedure, but you could also
modify the Call Stack and the variables before the beginning of the local
stack storage to have one procedure return to a procedure different that
the one that called it. I never found a good practical reason to send the
return to different proc, but I sure had fun writing code to do it. Just
for amusement, of course.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)



"Bob Phillips" wrote in message
...
It sure would, as would a property that tells you the calling procedure.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Jantje" wrote in message
ups.com...
Thanks Bob!
Your method is also an option for me.
It would have been a nice feature though...


On 15 feb, 12:14, "Bob Phillips" wrote:
No, afraid not, we would all love there to be one.

What I do is to create a global variable, and set it at the head of
each
procedure, painful, but I know of no better way.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Jantje" wrote in message

oups.com...



Hi, i just made a small sub 'logError' that writes the date, time,
err.Number and err.Description to a specified worksheet. I also want
to write the name of the Sub or Function that caused the error to be
raised...
Now i have to change the parameter each time i'm using the statement
'logError Date, Time, Err.Number, Err.Description, "name for sub or
function" '.
Can someone tell me if there's a variable to use that has the name of
a self made sub or function?
I hope the question is clear enough...
Thanks
jan- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -