SavePassword Property

Applies To

PivotCache object, QueryTable object.

Description

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