OLEDBConnection.ServerCredentialsMethod (Excel)

Returns or sets the type of credentials that should be used for server authentication. Possible return values are xlCredentialsMethodIntegrated, xlCredentialsMethodNone, xlCredentialsMethodStored.

ActiveWorkbook.Connections(1).OLEDBConnection.ServerCredentialsMethod = xlCredentialsMethodIntegrated