This can be hard coded into the QueryTable connection string. However
there are security and confidentiality implications.

Paul


"wpiet" wrote in message
...
How can I have a user enter login username & password to be used for
multiple
ODBC connections? I have a workbook with multiple sheets, each with a DB
query. My macro steps thru each sheet, refreshing the data.
For each 'Selection.QueryTable.Refresh,' the user must re-enter id &
password. How can I modify this to have the user enter this info only once
&
use it for each subsequent refresh?
--
Will