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.

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

Applies to | PivotCache Object | QueryTable Object