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