Searching for VBA Code

[cosmarchy]

Hi,

I have rather a lot of VBA spread across probably hundreds of Excel, Access and Word documents.

Is there any way of searching for VBA code within office files? It would be nice to catalog what I have got but being able to find function and sub names would be a good start.

You cannot search the file contents so was wondering whether there are any applications out there designed for this or maybe another way to search?

Thanks

[SamT]

You might have to join VBAExpress.com to see these:


http://www.vbaexpress.com/kb/getarticle.php?kb_id=1054
http://www.vbaexpress.com/kb/getarticle.php?kb_id=278
http://www.vbaexpress.com/kb/getarticle.php?kb_id=800
http://www.vbaexpress.com/kb/getarticle.php?kb_id=51
http:/www.vbaexpress.com/kb/getarticle.php?kb_id=398/

IMO, the last entry is most helpful.Although one of the earlier entries has 200 Procedures designed for your use.

https://peltiertech.com/list-vba-procedures-by-vba-module-and-vb-procedure/
http://www.cpearson.com/excel/vbe.aspx

You're looking at thousand(s) of Procedures when done. How do you intend to organize the list? I suggest by Application, then Full Address, File Name, Module Name, (ThisWorkbook" and Worksheets are Excel Modules,) Procedure Name, Parameters List ,Author, Comments.

I would start this search with a list of all Root Directories that need to be searched, then search each in Application order for relevant File extensions.