UpdateLink password protected files, VBA for Excel,
 

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

If you will always get a password dialog when updating the links you
could try using SendKeys to send the password

SendKeys "VerySecret~" ' the ~ is the Enter key
ActiveWorkbook.UpdateLink ....

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup