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

A

Aeronav

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to retrieve procedures ans functions names in VBA ? 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel 2003 - VBA to get a list of Module names in the project 4
VBA to capture (print or list) names of all Sub's or Function macro's in Personal.xls 7
Copying a Userform within the same project 1
Sharing VBA procedures; alternative to personal.xls? 5
How to call functions of a DLL in Excel and in a .net project 1
How to retrieve from Excel/VBA the SharePoint (v. 2003) user's ID when he/she is connected to a list 0

Top