Does anyone know how to search for a string within the code panes of the VBE project in Excel or Word.

I wish to do the following. ( in vBA )

1. From Excel open another excel workbook
2. Scan the VB project in this workbook for any instances of a specific string.

Help?