List of Functions

[Idris]

I am looking for a VB Code that would list down all the User define function and procedure. Like I know how to list the names of modules but now I want to list each and every function in each modules.

Can anyone in here explain me how to achieve this list?

Thanks

 

[WayneRyan]

Idris,

Hope this gets you started:

For i = 0 To Me.Application.Modules.Count
    Set ThisModule = Me.Application.Modules(i)
    strModuleName = OneModule.Name
    lngCountOfLines = OneModule.CountOfLines
    For j = 0 to lngCountOfLines
       strTemp = OneModule.Lines(j, 1)
       ' Parse the Module text line
       Next j
    Next i

Wayne

 

[Idris]

Thanks Wayne