Update Links

G

Guest

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro To Avoid Link Update of Open Files 2
Macro to Update links on a network 4
Excel Excel macro and passwords 3
Updatelink Error 1
On error 1
Macro update link 1
Update Password Protected Links 1
RUNTIME 1004 3

Top