How to list sub and function

[Le Nordiste]

Hi from Meudon (nearby Paris France)


I want to list all my subs and functions i have developped with VB in
Word, Excell and Access.
(Nor yet Outlook neither Powerpoint, but one day may be…)

How can i retrieve automatically these procedure name ?

Is it possible to also retrieve one particuliar line of comment
('keyword :-----) for instance


Thanks for your collaboration.


sent to MS.public.word.vba.beginners

 

[Jonathan West]

MZ-Tools for VBA has facilities for doing bthis sort of thing. It's a free
download.

http://www.mztools.com/v3/download.aspx


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

Hi from Meudon (nearby Paris France)


I want to list all my subs and functions i have developped with VB in
Word, Excell and Access.
(Nor yet Outlook neither Powerpoint, but one day may be…)

How can i retrieve automatically these procedure name ?

Is it possible to also retrieve one particuliar line of comment
('keyword :-----) for instance


Thanks for your collaboration.


sent to MS.public.word.vba.beginners

 

[Le Nordiste]

I am more interested in VB code , due to the fact i want to learn how
to act on the code itself.

Thanks for the freeware address

 

[David Horowitz]

Bonjour...
You can use the VBA Extensibility Library, which gives you access to each
line of code and also provides functions for peeking into procedures (Subs
and Functions). It could get complicated. But if you really want to do it,
I'm sure you'll figure it out.
There's an article on TechTrax ezine about using the VBA Extensibility
Library. Some guy named David Horowitz wrote it.
http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=307
This also applies to your question about listing unused variables two
threads ahead.
Good luck!
David