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-pro...-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.