SavePassword Property 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