theta
07-24-2012, 06:47 AM
Hi all...looking for some help on a project. I have inherited an existing excel solution (20,000 lines of code and 1,300 procedures).
I want to build a master tree to record the interaction of these modules. The easiest way to start would be to record each sub (and its parent module) called, along with each function (and parent module) called. There is an on open event that triggers this process.
I tried to do it manually but it quickly spirals into a few hours work - any way to print to a text file / workbook everytime a sub/function is called?
Thanks
I want to build a master tree to record the interaction of these modules. The easiest way to start would be to record each sub (and its parent module) called, along with each function (and parent module) called. There is an on open event that triggers this process.
I tried to do it manually but it quickly spirals into a few hours work - any way to print to a text file / workbook everytime a sub/function is called?
Thanks