QueryTable.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.
Syntax
expression.SavePassword
expression A variable that represents a QueryTable object.
Remarks
This property is used in both ODBC and OLEDB queries, and by both PivotTables and QueryTables.
Example
This example causes password information to be removed from the ODBC connection string whenever query table one is saved.
| Visual Basic for Applications |
|---|
|