This documentation is archived and is not being maintained.

SavePassword Property [Excel 2003 VBA Language Reference]

Office 2003

True if password information in an ODBC connection string is saved with the specified query. False if the password is removed. Read/write Boolean.


This property affects only ODBC queries.


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