I have a workbook with several queries to an external db. For all of them, I let Excel save both UserId and Password (not a big security concern, at the moment).
Quite often I need to run the same set of queries against different db schema, that is, by logging in using different UserId/Password...