OLEDBConnection.UseLocalConnection (Excel)

True if the LocalConnection property is used to specify the string that enables Microsoft Excel to connect to a data source. False if the connection string specified by the Connection property is used.

ActiveWorkbook.Connections(1).OLEDBConnection.UseLocalConnection = True