ODBCConnection.Connection (Excel)

Returns or sets a string that contains ODBC settings that enable Microsoft Excel to connect to an ODBC data source.

Setting the Connection property does not immediately initiate the connection to the data source. You must use the Refresh method to make the connection and retrieve the data.

ActiveWorkbook.Connections(1).ODBCConnection.Connection =