Catalogueing variables

[Don Wells]

Hi All
    I am putting together a debugging tool and have a need for snippets that will run in an excel vba macro to list all variables in a project and identify which module.procedure or project object,procedure holds them.
    I'm not asking anyone to develop new code for this; but if you have snippets that might be useful it would be greatly appreciated.

Many thanks in advance.
Stay safe

[HansV]

Not what you asked, but perhaps useful: Document Your Excel VBA Procedures.

[ChrisGreaves]

... will run in an excel vba macro to list all variables in a project and identify which module.procedure or project object,procedure holds them.

Hi Don.
I have an application "PROJE"ext that almost does this. Written in Word2003/VBA but operates on any VBA project (in Word, Excel, Outlook, PowerPoint etc)
It will list all procedures as subroutines or functions, public/private, calls to and calls from etc.
It has a "stripper"module that detects orphaned procedures and displays them for deletion.

It does not do symbolic data names, be they constants or variables, but I thought that (it did it might have been in an earlier version - I am up to PROJE164 right now).

I do recall analyzing CONST and DIM statements at sometime in the past.

(1) How badly do you want symbolic data names?
(2) Do you want to take a look at the PROJE164 code as it is today?

[later] I think I may have the code. I found the attached procedure just now, which (procedure) suggests that I am looking for symbolic data names.
Cheers
Chris