Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to retrieve procedures ans functions names in VBA ? | Excel Programming | |||
Finding Unreferenced Subs and Functions | Excel Programming | |||
Common Functions and Subs | Excel Discussion (Misc queries) | |||
Where to Place Public Subs and Functions | Excel Programming | |||
Called subs versus functions | Excel Programming |