OLEDBConnection.RefreshDate (Excel)

Returns the date on which the OLE DB connection was last refreshed.

For OLAP data sources, this property is updated after each query.

Dim dtRefreshDate As Date
dtRefreshDate = ActiveWorkbook.Connections(1).OLEDBConnection.RefreshDate