Is there any way to generate documentation for a VBA script Basically, I would like to get a list of variables, functions and subroutines for each page that I am writing. I could create it, no problem but is there a way to autogenerate it
Generating Documentation
Hot Topic
- Outputting to a Listbox
- Outputting to a Listbox
- Sorry it may not have been clear as>>
- Using ApplyCustomType with variable numbers and types of series
- Making process modal
- asp .Net 2.0 --> The specified module could not be found. (Exception from HRESULT: 0x8007007E)
- Personal.xls
- Calling c# assembly - Works from Excel 2003, not from XP
- converting text to Hours Minutes and Seconds
- Projects, objects & modules
Microsoft ISV
- "Bizzare" Sendkey Code in Excel
- Can't Edit the View >> Set ArithAbort unclear
- Outlook 2003 Scripting - Working with encripted messages
- Undo Command(EXCEL)
- Need help with a macro (not sure if correct site... thx)
- Parse Text from displayed Desktop
- How do I open CSV using Excel without deleting leading zeros?
- Count and display in cell
- How to show dates in forms by the order of time?
- If a cell has value add a formula to neighbouring cell
Generating Documentation
Fluxtah
Hi
Yeah this is possible as you can parse the VBProject. Here is a link that has information on what your looking for. About half way down there is a section on how to list all modules in a workbook and one to list all procedures in a module.
http://www.cpearson.com/excel/vbe.htm