SavePassword Property [Excel 2003 VBA Language Reference]
True if password information in an ODBC connection string is saved with the specified query. False if the password is removed. Read/write Boolean.
This property affects only ODBC queries.
This example causes password information to be removed from the ODBC connection string whenever query table one is saved.
Worksheets(1).QueryTables(1).SavePassword = False