How to get Data Connection Last Refreshed Date Time

Hi.
I am trying to find out how to obtain the Last Refreshed date\time from the data connections box in Excel.
I can find Workbook.BuiltinDocumentProperties("Last Save Time") which appears to return the Date\time that the document was saved, but not the data refresh.
My spreadsheet has numerous data sources that can be refreshed by different users at different times, so want to be able to report on a Cover sheet when all the various data was refreshed.
Any help would be much appreciated.

Depends on connection type.

For below types of connection there's RefreshDate property.
DataFeedConnection
ODBCConnection
OLEDBConnection
PivotCache
PivotTable