Update Links

[psamu]

I would appreciate your help, I have two workbook and one is linked to another one and read only. I just wanted to update automatically when I update the main one evenif some users open the linked workbook. (In the background without seeing linked workbook need to be updated immediately) Thanks.

 

[Andrew Poulsom]

You can only update links when the target workbook is open and the source workbook has been saved to disk.

 

[psamu]

Is there anyway if the other workbook already open by other users in readonly? Source workbook saving is fine.

 

[Andrew Poulsom]

If the target workbook is open the links can be updated via Edit|Links|Update Values.

 

[psamu]

I would like to have some vba for when master file close then open the linked workbook (password protected) and update the link and save and close.

 

[psamu]

Below code works fine, but if the file protected with the password then asking for the password. How do I add the password in below code. Thanks


Private Sub Workbook_BeforeClose(Cancel As Boolean)
If ThisWorkbook.ReadOnly Then
ThisWorkbook.Saved = True
End If
Workbooks.Open "F:\Accounting\TestSub.xls", UpdateLinks:=xlUpdateLinksAlways
ActiveWorkbook.Close SaveChanges:=True
End Sub

 

[Andrew Poulsom]

The Open method has a Password argument:

Workbooks.Open "F:\Accounting\TestSub.xls", UpdateLinks:=xlUpdateLinksAlways, Password:="YourPassword"

 

[psamu]

I put that code, but still asking for password.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If ThisWorkbook.ReadOnly Then
ThisWorkbook.Saved = True
End If
Workbooks.Open "Q:\Accounting\TestSub.xls", UpdateLinks:=xlUpdateLinksAlways,
Password:="Test"
ActiveWorkbook.Close SaveChanges:=True
End Sub

 

[Andrew Poulsom]

Did you use the correct password in your code? What prompt do you get from Excel?

 

[psamu]

Same password "Test" It is simply prompting fore the password. (Reserved by ....... Enter password for write access, or open read only. Password..............