Can you get a log of the "thread" of lines used, when your macro run?
You might already know about these methods, but here's some possibilities I
can think of:
You could just put a breakpoint at the area that you're interested in, run
the code, and then once it's reached your breakpoint, View|Callstack
(Ctrl+L).
Or you could put Debug.Print "functionname" at the start of each
sub/function (or write a program to insert this line in each sub/function
for you). Then after running your macro you could View|Immediate Window
(Ctrl+G) to see all of the sub/functions that were called.
-Erik
"Marie J-son" wrote in message
...
Hi,
When a macro run and by calls jump between procedures, it would be great
to get a log of the "tread" line by line. That would make it more easy to
debug, right? Is there a software or a way to achieve this?
/Regards
|