Does anyone know of EXCEL VBA freeware (not visio, not commercial) that goes through your VBA Project and documents the call stack with whatever object types, names and signitures it happens to encounter after Activate, and then, since its not possible to tell what a user will do next, at least acknowledge and catalog the existence of a Sub or Function in a Module,Form,Worksheet,NamedRange/NamedFormula...I must have missed a few, and annotates which other data types, objects, subs or functions it uses or is used by?
I started working on a project, thought ok, spawn as many modules as you need, collect like minded subs by affinity either by function or by data and go from there. Paradoxically, organization broadens your scope, and the next thing you know your three modules are 12, and one of them is named BoulevardOfBrokenDreams.
Know of a freebie Excel based diagrammer app for systems analysis of VBA?
Thanks very much in advance.
I started working on a project, thought ok, spawn as many modules as you need, collect like minded subs by affinity either by function or by data and go from there. Paradoxically, organization broadens your scope, and the next thing you know your three modules are 12, and one of them is named BoulevardOfBrokenDreams.
Know of a freebie Excel based diagrammer app for systems analysis of VBA?
Thanks very much in advance.
Last edited:
