Useful
Active Member
- Joined
- Mar 16, 2011
- Messages
- 494
Hi,
I try to write the code that formula updates on protected Workbooks with VBA but something is wrong what?
P.S: but i know that when use command "open and close workbook" it works but i want to update links without opening the protected workbook. (I don't want to open the sourse, simply i want to update links)
Thanks in advance!
I try to write the code that formula updates on protected Workbooks with VBA but something is wrong what?
Code:
Sub Update()
ActiveWorkbook.UpdateLink Name:= _
"C:\Documents and Settings\*******.xls", Type:=xlExcelLinks, Password:="5"
End Sub
P.S: but i know that when use command "open and close workbook" it works but i want to update links without opening the protected workbook. (I don't want to open the sourse, simply i want to update links)
Thanks in advance!