Need a little help please. Is there a way to automatically update links without having to enter the password for each workbook. I have a workbook that collects data from a number of workbooks (sources). The sources are password protected. Every time I open the workbook that collects the data it wants the password for each source workbook. Is there a way to get around this process?
I'm currently trying this code but, it's not working. Can anyone see anything wrong with it?
Sub Open_Protected_File() Workbooks.Open Filename:=D.Shane_Prod_Log.xlsx C: Department Records - admin \ XXX_XX_XX_XXX \ D.Shane_Prod_Log.xlsx, Password:="Dperic#7" End Sub