Hello!
I have problem with VBA for EXCEL. In formulas there are links to other
files . When it's open it normally connects with other files and everything
is OK, but the other files are open protected with a password, so each time
I have to put the password manually. There are MANY files so it is not very
convenient. All files are protected with exactly the same password.

I use such piece of code:

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LINKSOURCES

How to write the code so that it can automatically use the same password
during connecting to these files? Without opening them each time.
Can anybody help me?

thks.
Adam