Here’s a way to automatically publish documentation about every VBA project, module, procedure and class in the currently open Workbook. There are four options for output, each directly from Excel.
- Google interactive table
- Static html web page
- A Google Apps Script Skeleton
Example of Google Interactive table
Example of Static version
Example of jSon version
How does it work ?
Public Sub docProjectsExecute(Optional outputType As String = "google", _ Optional moduleList As Variant = Empty, _ Optional fn As String = vbNullString)
figure out the return type of a procedure
Load to cJobject structure
Case "json" content = job.serialize(True)