theta
04-22-2013, 07:37 AM
All,
I have requested information on this site a few times relating to call tree listings. This seems to be a bit of a struggle for VBA / not widely used, as the responses were of limited use. When inheriting large projects (mine was 38,000+ code lines) it is very useful to view the call tree.
For the benefit of any members here (or googlers) I have found a working solution that I am currently modifying (to run on single procedures, not entire lists).
My previous requests are listed here :
http://www.vbaexpress.com/forum/showthread.php?t=45945
http://www.vbaexpress.com/forum/showthread.php?t=45832
http://www.vbaexpress.com/forum/showthread.php?t=43525
http://www.vbaexpress.com/forum/showthread.php?t=43163
But the answers did not solve the issue. The easiest solution is to buy Project Analyzer, but I like the $299 in my pocket thank you very much.
After spending a large number of accumulated hours searching, testing and downloading - I have the following :
CallTree97 Add-In (the attached is the version I have updated)
Download 2003 - 2010 adjusted file >>> CallTree97.xla (http://www.mediafire.com/file/tvf3fqb2dont7w7/CallTree97.xla)
Download original file from publisher >>> http://www.oaltd.co.uk/DLCount/DLCount.asp?file=CallTree97.exe
NOTE : OALTD is a great resource, although some of the files are a bit outdated. "They said it couldn't be done" :)
There are other workbooks that I have been playing with. The approach on the first attachment is especially 'elegant' :
VB_MakeTree Recursive Loop (http://www.mediafire.com/file/714akkh3jhn69ra/VB_MakeTree.xlsm)
ToUHSite (http://www.mediafire.com/file/mno6vnfi3nbqn1n/ToUHSite.xlsm)
I hope this is beneficial to the community. I am going to try and adapt it to produce a function that can be called to produce a tree for a given ROOT procedure e.g. GetCallTree("VB_System.Auto_Open"), or I will adjust the existing so that items can be removed from the ProcList label to restrict which subs/functions are analysed (for speed and efficiency).
I have requested information on this site a few times relating to call tree listings. This seems to be a bit of a struggle for VBA / not widely used, as the responses were of limited use. When inheriting large projects (mine was 38,000+ code lines) it is very useful to view the call tree.
For the benefit of any members here (or googlers) I have found a working solution that I am currently modifying (to run on single procedures, not entire lists).
My previous requests are listed here :
http://www.vbaexpress.com/forum/showthread.php?t=45945
http://www.vbaexpress.com/forum/showthread.php?t=45832
http://www.vbaexpress.com/forum/showthread.php?t=43525
http://www.vbaexpress.com/forum/showthread.php?t=43163
But the answers did not solve the issue. The easiest solution is to buy Project Analyzer, but I like the $299 in my pocket thank you very much.
After spending a large number of accumulated hours searching, testing and downloading - I have the following :
CallTree97 Add-In (the attached is the version I have updated)
Download 2003 - 2010 adjusted file >>> CallTree97.xla (http://www.mediafire.com/file/tvf3fqb2dont7w7/CallTree97.xla)
Download original file from publisher >>> http://www.oaltd.co.uk/DLCount/DLCount.asp?file=CallTree97.exe
NOTE : OALTD is a great resource, although some of the files are a bit outdated. "They said it couldn't be done" :)
There are other workbooks that I have been playing with. The approach on the first attachment is especially 'elegant' :
VB_MakeTree Recursive Loop (http://www.mediafire.com/file/714akkh3jhn69ra/VB_MakeTree.xlsm)
ToUHSite (http://www.mediafire.com/file/mno6vnfi3nbqn1n/ToUHSite.xlsm)
I hope this is beneficial to the community. I am going to try and adapt it to produce a function that can be called to produce a tree for a given ROOT procedure e.g. GetCallTree("VB_System.Auto_Open"), or I will adjust the existing so that items can be removed from the ProcList label to restrict which subs/functions are analysed (for speed and efficiency).