Update Links from a password encrypted workbook

[leirbag]

Hi,
I want to update the links in a master workbook (I & GGAA - 1.10.1 (P).xls) that points to 10 password encrypted workbooks. Every time i open the master it asks me for the password. Is there a way to make it update automatic?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I got this code, but it doesn´t work:<o></o>
Workbooks.Open "D:\Documents and Settings\jgarcia\Desktop\MM\Presupuesto\1.8 Gerencia Recursos Humanos\Auxiliar\Gastos de Personal - 1.8 (P).xls", Password:="mm1273", WriteResPassword:="mm1273",UpdateLinks:=0 <o></o>
<o> </o>
THe workbook is not protected, the file is password encrypted.... the same person who can see the master, cannot see the slave.<o></o>
<o> </o>
Thanks<o></o>

 

[leirbag]

i got this code,,, what is wrong???


Sub TestPassword()
Workbooks.Open Filename:="D:\Documents and Settings\ino\Desktop\MM\Pres\1.8 G. R. H.\Auxiliar\GP - 1.8 (P).xls", UpdateLinks:=3, _
Password:="magna1273"
Workbooks.Open Filename:="D:\Documents and Settings\ino\Desktop\MM\Pres\1.1 A. G.\GGAA - 1.1 (P2).xls", UpdateLinks:=3
Workbooks("D:\Documents and Settings\ino\Desktop\MM\Pres\1.8 G. R. H.\Auxiliar\GP - 1.8 (P).xls").Close
End Sub