A powerful search program that uses regular expressions to search every object in an an Excel Workbook. Workbook Search Engine is a powerful search program that uses regular expressions to search every facet of an Excel workbook.
Here are just a few commonly used searches.
1) Search the Values and/or Formulas of every worksheet cell and get a report listing all matches.
2) List all VBA References in a set of workbooks and indicate any missing references.
3) Find all SQL statements in the VBA code, worksheet queries and pivot sources.
4) Find all hard coded login credentials in the VBA code, worksheet queries, pivot sources and Connect strings.