OLEDBConnection.MakeConnection (Excel)

Establishes a connection for the specified OLE DB connection.

The MakeConnection method can be used when a connection drops and the user wants to reestablish the connection. Various objects and methods might return a run-time error if the connection is dropped. Use of this method assures a connection before executing other objects or methods.

ActiveWorkbook.Connections(1).OLEDBConnection.MakeConnection