ODBCConnection.ServerCredentialsMethod procedure builder

ODBCConnection.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).ODBCConnection.ServerCredentialsMethod = xlCredentialsMethodIntegrated