Update Links
 

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

Update Links
 

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.



Steven wrote:

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