Avoid "...contains one or more links that cannot be updated" message.

[Craig]

I use Excel2002 & I use code to sequentially open, refresh, save &
close 30 files from a master Excel file. On opening each file the
message appears "This workbook contains one or more links that cannot
be updated." I have a choice of buttons 'Continue' or 'Edit Links'.
The links are ok so I want to avoid this message.

Thankyou in advance

 

[Bill Manville]

On opening each file the
message appears "This workbook contains one or more links that cannot
be updated." I have a choice of buttons 'Continue' or 'Edit Links'.
The links are ok so I want to avoid this message.

Try
Application.DisplayAlerts = False
Workbooks.Open TheFileName, UpdateLinks:=0
Application.DisplayAlerts = True

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup