ODBCConnection.SavePassword (Excel)

True if password information in an ODBC connection string is saved in the connection string. False if the password is removed.

This property is used in both ODBC and OLE DB queries, and by both PivotTables and QueryTables.

ActiveWorkbook.Connections(1).ODBCConnection.SavePassword = True