DataFeedConnection.ServerCredentialsMethod (Excel)

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

Following are the types of credentials that may be used:

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