Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of running sub???
Is there a way to access the name of a current sub via VBA while a macro is
running? TIA, Ken |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of running sub???
You can code the name of the sub with in it. Excel isn't multitasking. So
you can design the sub to know about itself. - Regards, Tom Ogilvy "Ken Loomis" wrote in message ... Is there a way to access the name of a current sub via VBA while a macro is running? TIA, Ken |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of running sub???
Thanks, Tom.
I hard coded the name of the sub into all the subs so that I can call a routine that will adds the name of the sub to a extra sheet in the workbook to track the progress. I have posted that in another question because it works in my Excel 2003, but bombs in Excel 2000. Ken "Tom Ogilvy" wrote in message ... You can code the name of the sub with in it. Excel isn't multitasking. So you can design the sub to know about itself. - Regards, Tom Ogilvy "Ken Loomis" wrote in message ... Is there a way to access the name of a current sub via VBA while a macro is running? TIA, Ken |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of running sub???
If you are doing this for debugging purposes, you might use the call stack
functionality in the VBE. -- Regards, Tom Ogilvy "Ken Loomis" wrote in message ... Thanks, Tom. I hard coded the name of the sub into all the subs so that I can call a routine that will adds the name of the sub to a extra sheet in the workbook to track the progress. I have posted that in another question because it works in my Excel 2003, but bombs in Excel 2000. Ken "Tom Ogilvy" wrote in message ... You can code the name of the sub with in it. Excel isn't multitasking. So you can design the sub to know about itself. - Regards, Tom Ogilvy "Ken Loomis" wrote in message ... Is there a way to access the name of a current sub via VBA while a macro is running? TIA, Ken |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of running sub???
Tom,
Yes, I am trying to debug my VBA. I have to send my workbooks to someone that knows little about this stuff. And, then I am trying to get info back to help me debug this. When you mentioned the "stack" that seemed very appropriate. As a side note, I used to program in FORTH, which was TOTALLY stack based. Anyone rememebr FORTH?????? Where can I look to learn more about :"call stack functionality in the VBE"? TIA, Ken "Tom Ogilvy" wrote in message ... If you are doing this for debugging purposes, you might use the call stack functionality in the VBE. -- Regards, Tom Ogilvy "Ken Loomis" wrote in message ... Thanks, Tom. I hard coded the name of the sub into all the subs so that I can call a routine that will adds the name of the sub to a extra sheet in the workbook to track the progress. I have posted that in another question because it works in my Excel 2003, but bombs in Excel 2000. Ken "Tom Ogilvy" wrote in message ... You can code the name of the sub with in it. Excel isn't multitasking. So you can design the sub to know about itself. - Regards, Tom Ogilvy "Ken Loomis" wrote in message ... Is there a way to access the name of a current sub via VBA while a macro is running? TIA, Ken |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of running sub???
http://msdn.microsoft.com/library/de...uggingcode.asp
Make sure the TOC is visible on the left, look at the sub topics. -- Regards, Tom Ogilvy "Ken Loomis" wrote in message ... Tom, Yes, I am trying to debug my VBA. I have to send my workbooks to someone that knows little about this stuff. And, then I am trying to get info back to help me debug this. When you mentioned the "stack" that seemed very appropriate. As a side note, I used to program in FORTH, which was TOTALLY stack based. Anyone rememebr FORTH?????? Where can I look to learn more about :"call stack functionality in the VBE"? TIA, Ken "Tom Ogilvy" wrote in message ... If you are doing this for debugging purposes, you might use the call stack functionality in the VBE. -- Regards, Tom Ogilvy "Ken Loomis" wrote in message ... Thanks, Tom. I hard coded the name of the sub into all the subs so that I can call a routine that will adds the name of the sub to a extra sheet in the workbook to track the progress. I have posted that in another question because it works in my Excel 2003, but bombs in Excel 2000. Ken "Tom Ogilvy" wrote in message ... You can code the name of the sub with in it. Excel isn't multitasking. So you can design the sub to know about itself. - Regards, Tom Ogilvy "Ken Loomis" wrote in message ... Is there a way to access the name of a current sub via VBA while a macro is running? TIA, Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Sum | Excel Worksheet Functions | |||
RUNNING Avg - how? | Excel Discussion (Misc queries) | |||
running sum | Excel Discussion (Misc queries) | |||
Keep Running Tab | Excel Discussion (Misc queries) | |||
Running Add-In from VBA | Excel Discussion (Misc queries) |