Listing all macros

[Martijn van Welie]

Hi,

I am working on some code to add all automatically macros to a custom
menu. I know how to added items to a menu.

What I don't know is how to list all macro's that are embedded in a
document. Is there a method GetMacros() or something like that?

Any ideas?

Best regards,

Martijn van Welie

 

[junethesecond]

My recomendation is to study vbaunit written by Rob Harwood.
http://www.rapid-programming.com/vbaunit/vbaunit.zip
In vbaunit,there is afunction to find macro.

Private Function IsTestMethodLine _
(Line As String) As Boolean
IsTestMethodLine = Left(Line, 15) _
Like "Public Sub Test"
End Function