
Originally Posted by
firefytr
You know what would be really cool? Is to show (on top of something like this) all subs/procedures in all installed add-ins also. Now THAT would be something useful.

Hey Zack,
The following will return you the collection, and could be incorporated into anything here:
Dim wb As AddIn
For Each wb In Application.AddIns
Debug.Print wb.Name
Next wb
The kicker is though, when I used it with my file (attached), I got a list of all my addins, but most were password protected, so I couldn't access them.
On the rest of the thread...
Regarding the file attached, as mentioned before, I set this up with intentions of making it a code copier. Something easy for use in setting up a new workbook with pre loaded procs. It isn't completely finished (I never did get to writing the code to actually copy the procedures,) but it does collect all procedures in any given module, userform, etc. and ask you where you want to put them. (If you go all the way to finish, it will even tell you what was selected.
Checkboxes are on the userform to filter in/out certain classes of modules.
In order to bypass the addin protection issue, I set up a list of addins that I can access on a defaults page, in addition to some default settings for the checkbox.
At any rate... I'm hoping to finish it at some point, but maybe there's some code in here that someone finds useful.
(This is more to the procedure listing side, rather than getting things from all files as Johnske is looking for though.... could be a base, maybe, or just an idea farm...)
Cheers,