Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My links don't update | Excel Discussion (Misc queries) | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
update links | Excel Discussion (Misc queries) | |||
Excel 2003 - Update or Don't Update Links Problem | Excel Programming | |||
can't update links...can't find links | Excel Discussion (Misc queries) |