OLEDBConnection.SavePassword (Excel)

True if password information in an OLE DB 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).OLEDBConnection.SavePassword = True