Find 14)

14) Find MOST Data Sources Associated With Active Workbook

Returns the data sources behind Pivot Tables and Query Def objects that may be populating your workbook. Also returns the connection strings.

Can be used to develop an understanding of what data is required to build a connection string to a specific data base or what a SELECT statement might look like.

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc