Open workbook without update all linked information

[Warren]

I am writing a macro which opens and closes a series of workbooks. One of
the workbooks contains formula that have links to other workbooks. So, the
macro stops when it tries to open this workbook and ask if I want to update
all linked information.

Is there a code that specifically tells Excel to open workbooks and if it
contains links, do not update all the linked information?

I think this works:
Application.DisplayAlerts = False
But this one surpresses all alerts.

Thanks in advance

Warren

 

[Tom Ogilvy]

I don't believe displayalerts works in this case. What does work is the
second argument to the workbooks.open method

workbooks.open filename:="Whatever", UpdateLinks:=0

 

[Warren]

Thanks Tom.

....and you are right, DisplayAlert does not work...

Regards,
Warren