| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
QueryTable.SavePassword property (Excel) |
vbaxl10.chm518085 |
|
|
c17250b1-9f80-12ed-1cbf-9f54a05ebaf3 |
05/03/2019 |
medium |
True if password information in an ODBC connection string is saved with the specified query. False if the password is removed. Read/write Boolean.
expression.SavePassword
expression A variable that represents a QueryTable object.
This property is used in both ODBC and OLE DB queries, and by both PivotTables and QueryTables.
If you import data by using the user interface, data from a web query or a text query is imported as a QueryTable object, while all other external data is imported as a ListObject object.
If you import data by using the object model, data from a web query or a text query must be imported as a QueryTable, while all other external data can be imported as either a ListObject or a QueryTable.
Use the QueryTable property of the ListObject to access the SavePassword property.
This property is ignored if the ListObject is connected to a SharePoint list.
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[!includeSupport and feedback]