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

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 :-)

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

Craig wrote:
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