Create mindmap for vba modules

  • 1
  • Question
  • Updated 12 months ago
I do a lot of VBA coding and sometimes I need to do troubleshooting, on my own and other peoples Macros.

Every time, it is helpful to understand the flow of the macro, and a mindmap comes to mind. HOwever manually creating the mindmap is very time intensive. 

I may have to write up the code myself to do what I want but before I do, I figured I would ask if it has been done or any ideas on where you would start. I already have created and modified some code that will list all of the modules and macros in a project, however, I need to add to that code to add the references and calls from one module to another, then display that in a way that I can import or convert into a mind map.

PLEASE HELP.

Thanx in advance.
Photo of DeLaguna

DeLaguna

  • 3 Posts
  • 0 Reply Likes
  • inquisitive

Posted 12 months ago

  • 1
Photo of aHa!Coaching

aHa!Coaching, Champion

  • 1192 Posts
  • 116 Reply Likes
Did you have a look at this direction: https://docs.microsoft.com/en-us/dotnet/visual-basic/programming-guide/program-structure/documenting... This would mean that if you use the right comments etc, documentation about your project will automatically generated in XML. You could then transform the XML to MindManager's XML map format by using a XSLT transformation.

Is that something you could use?
Photo of DeLaguna

DeLaguna

  • 3 Posts
  • 0 Reply Likes
I am going to look into this, I am using the VBA in excel modules and while I comment extensively, not all the code was created by me, however, I do like this idea and am going to investigate further.
Photo of Ary Velstra, Expert Trainer

Ary Velstra, Expert Trainer

  • 1292 Posts
  • 197 Reply Likes
Or, maybe even easier....;-)
Copy your coding into MSWord or Excel and import it into MIndManager for Windows?
Photo of DeLaguna

DeLaguna

  • 3 Posts
  • 0 Reply Likes
While I like your idea, I am not sure that it will be able to do what I need due to all the surrounding code. Unless maybe I didn't fully understand your proposal.
Photo of Ary Velstra, Expert Trainer

Ary Velstra, Expert Trainer

  • 1292 Posts
  • 197 Reply Likes
Why not try it and see what happens?
Photo of Ary Velstra, Expert Trainer

Ary Velstra, Expert Trainer

  • 1292 Posts
  • 197 Reply Likes
The better way, and  to avoid these steps, is to use MindManager as your creative developers startingpoint.
Type (or copy) the code in your topic notes and use the notes with tags etc etc to be able to find what you may re-use in other projects.

In the beginning this may seem extra work, but after very little time, you will find the benefits of this approach
(Edited)