Update Links

[Steven]

I want to update links in an AutoOpen macro. The source file is passworded.
I have tried working with:

ActiveWorkbook.UpdateLink Name:="C:\Book2.xls", Type:=xlExcelLinks

but it asks for the password to update. Is there a way to do this code so I
can password the source file and have the Update Link process work without
the user having to input the password.

Thank you for your help.

Steven

 

[Dave Peterson]

You could have a macro that opens the workbook (book2.xls) and provides the
password.

Then it opens your real workbook.

Then it could close book2.xls (since it's done with it)

And finally closes itself.