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