updateLink; files with passwords , VBA help!

Hello!
does anybody know how to write code which is able to make a file taking
data from another files which are open-protected with a password?

I use such code:

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LINKSOURCES

It works but I have to put the password manually .
but my file pulls data from MANY files. So it is not convenient... How to
write the code so that it can automatically use the same password during
connecting to these files? All files are protected with the same password.

thks.
Adam



.