I have an Excel file with multiple VBA-Macros. For documentation purposes I want to create a UML Call Diagram, or similar that represents which macro calls which other one.
Is there a way to automatically create one?
Asked
Active
Viewed 1,897 times
1 Answers
2
Based on Engineer Toast's comment (and expanded with some screenshots of the respective tools):
People have made tools for exactly this. Google "document vba project"
Here's one that costs money: Aivosto (Project Analyzer Enterprise Edition)
Here's one that doesn't: contextures.com/ExcelTemplates/ExcelVBACodeDoc.zip (direct link)
Project Analyzer screenshot
ExcelVBACodeDoc screenshot
(I guess this is not exactly what you wanted, since it creates no diagram but rather a list of procedures)
Marcus Mangelsdorf
- 1,416