SavePassword Property
True if password information in an ODBC connection string is saved with the specified query. False if the password is removed. Read/write Boolean.
Remarks
This property affects only ODBC queries.
Example
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