ODBCConnection.RefreshDate (Excel)

Returns the date on which the ODBC connection was last refreshed.

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

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