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

[macropod]

Searching the VBA code (which is not especially difficult) would require programmatic access to the VBA code in the Office files concerned. Doing that would in turn require giving trusted access to the VBA environment, which is a significant security risk.

Although the code in the following link doesn't actually extract VBA code, it should give you a reasonable idea of what's involved:
Use VB script to paste code into a module? (microsoft.com)
The code to Copy A VBA Module From One Document To Another would be most relevant to your project.

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