SavePassword Property
From Microsoft Excel Visual Basic
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