Safe way to refresh many connections without saving the password?

I have a report with multiple (say 50) connections (qeries) into several databases. I don't wanna save the password with the connections. This leads to interesting CTRL+V excercise when refreshing all the connections. Is there a way I can avoid both saving and multiple pasting the password? Say a macro, that would prompt for database and password and refresh all connections within given database? Or some other workaround?

Any help would be appreciated! Thanks

Bump no response.

Anyone working with many connections?

Bump no response. Trying the last time .

Yes, you can.
But i'd need to see a sample sheet in order to code it well to you.

Basically what you need to do is refresh the querytable connections from VBA and parse the passwords along with them, then password protect your VBA code.

Thanks, JasperD,

I think I'm not allowed to upload anything from my work. But maybe what you need is only the connnection properties?

It looks like this:

Connection name: MyConnection1
Connection string: Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=MyID1;Data Source=MyDB;Extended Properties=""
Command type: SQL
Command text: select * from MyTable1

And analogically for MyConnection2 - MyConnection50

Let me know if you meant something else.

Thanks a lot!