如何同时更改多个查询中的UserId / Password

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 (s). Is there a way (even with VBA) to set the same UserId/Password for all my queries simultaneously , without having to modify each query's properties?I have a workbook with several queries to an ex