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