VBA Display Workbook Connections "Last Refreshed" in a Cell

[Bench]

Hi,

I'm looking for a way to display the "Last Refreshed" date and time in a cell.

I know you just have to click "Data>Connections" to see this but as the workbook has lots of connections it would be really handy to see these in a cell on my variables sheet.

Any ideas? Either VBA or somekind of Formula.

Thanks in advance.

 

[Bench]

Bump