How to retrieve subs and functions names of a project using VBA ?
 

Good morning,
I am using WIN XP SP2 and Excel 2007
Microsoft explains in kb274680 (in french, same number in english ?) how to
retrieve procedures and
functions names of projects, but the method uses C++, which I do not have.
Is there a way to do the same thing using VBA, from Excel VBIDE ? I need it
to create more easily a customUI for Excel 2007 Ribbon.
Thanks,
--
Aeronav

How to retrieve subs and functions names of a project using VBA ?
 

See www.cperason.com/Excel/vbe.htm for example code to list procedures.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Aeronav" wrote in message
...
Good morning,
I am using WIN XP SP2 and Excel 2007
Microsoft explains in kb274680 (in french, same number in english ?) how
to retrieve procedures and
functions names of projects, but the method uses C++, which I do not have.
Is there a way to do the same thing using VBA, from Excel VBIDE ? I need
it
to create more easily a customUI for Excel 2007 Ribbon.
Thanks,
--
Aeronav

How to retrieve subs and functions names of a project using VBA ?
 

See www.cperason.com/Excel/vbe.htm for example code to list procedures.

Or even http://www.cpearson.com/Excel/vbe.htm assuming you want to spell
your name correctly.<g

Rick

How to retrieve subs and functions names of a project using VBA ?
 

Thanks to Pearson and Rothstein, I think I can make it now
Aeronav

"Rick Rothstein (MVP - VB)" a écrit dans
le message de news: ...
See www.cperason.com/Excel/vbe.htm for example code to list procedures.

Or even http://www.cpearson.com/Excel/vbe.htm assuming you want to spell
your name correctly.<g

Rick