L
Legacy 365251
Guest
HI,
I would like to update file links for which are set passwords to open. If I use code
I get updating links but I have to give all passwords to files. I would like to do that without opening workbooks and giving a password.
I'm trying to that by below, but information "Named argument not found" is return.
How should I do it to get what I want?
Thanks in advance for help
I would like to update file links for which are set passwords to open. If I use code
Code:
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources
I'm trying to that by below, but information "Named argument not found" is return.
Code:
ActiveWorkbook.UpdateLink Name:="G:\users\Log\Master KPI data\Strefa wysyłek\Wysyłki.xlsm", Type:=xlExcelLinks, Password:="wysylki"
How should I do it to get what I want?
Thanks in advance for help