Thanks Marc - will check it out.
>and how about setting the "updatelink" parameter in the workbooks.open method as suggested here
http://msdn.microsoft.com/en-us/library/office/ff194819.aspx , although I guess your googling is as good as mine :)
>
>
>
>>Yes I have but the message still appears.
>>
>>
>>>have you tried oExcel.displayalerts = .f. ?
>>>
>>>
>>>
>>>
>>>>Hi Al,
>>>>
>>>>I am extracting some info from a set of XLS files. I am using automation for this and it works fine. Sometimes however an XLS file contains some links to some external source and message box pops up saying "This workbook contains links to other data source. To update click Yes, To keep existing info click No". At this point my app stops processing obviously. How can I avoid these popups from Excel and always choose the No option (because I do not have access to the external source)?
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.