generating Source Code Documentation

**moschen** · 08-07-2009, 09:20 AM

Hi,
is there a way to generate source code documentation for all the excel vba code that is in a workbook? Something like what JavaDoc does for Java?

If not, is there a way to programmatically access and export all VBA code of a workbook into text files?

Best regards,
Mo

**Andy Pope** · 08-07-2009, 09:28 AM

Not sure what JavaDoc's produces.

Is then of any use?
http://www.appspro.com/Utilities/Documentor.htm

Here is how to code for the VBE
http://www.cpearson.com/Excel/VBE.aspx

**moschen** · 08-07-2009, 10:41 AM

Thanks for the quick reply!

Documentor is nice, but not excatly what I am looking for, so I will probably have to use your other reference to build something on my own.

My idea was to create a document showing the various sheets, modules, etc. together with their procedures and functions as well as the comment that belongs to that function/procedure. So it should not only list the name of the procedures/functions, but also give a description of them.

Best regards,
Mo