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?