OLEDBConnection.ServerCredentialsMethod procedure builder

OLEDBConnection.ServerCredentialsMethod (Excel)

Returns or sets the type of credentials that should be used for server authentication.

Possible Values are xlCredentialsMethodIntegrated, xlCredentialsMethodNone, xlCredentialsMethodStored.
ActiveWorkbook.Connections(1).OLEDBConnection.ServerCredentialsMethod = xlCredentialsMethodIntegrated