OLEDBConnection.Reconnect Method (Excel)
Drops and then reconnects the specified connection.
Version Information
Version Added: Excel 2010
Syntax
expression .Reconnect
expression A variable that represents an OLEDBConnection object.
Example
The following code example causes the specified connection to reconnect.
ThisWorkbook.Connections(1).Reconnect