Hello,

I have 2 workbooks conected: a.xls and b.xls

b.xls has links to a.xls.

When b.xls is opened I am trying to get rid of the message box "This workbook contains links to other data sources... Update Don't Update".

Since this will be used by different persons I want to make b.xls to auto update the links without asking the user.

I found on google this code:
Workbooks.Open Filename:="C:\My Documents\a.xls", UpdateLinks:=3
but I think this opens the workbook in the link instead of auto updating the opened workbook.

Is there a way to set b.xls to auto update without asking via VB?

Thanks