Get Workbook Connection Properties from closed workbooks

[RLG_1204]

Is there a way to get workbook connection properties (i.e. connection string, command text, etc.) from closed workbooks via VBA? Any direction on how to get this information is much appreciated.
Thank you.

 

[Fazza]

For sure the files will need to be opened, then loop through the objects & read the connection strings & SQL.