Hi Sergey

I was betting you would have the answer. I did look through the oExcel object in the debugger but I missed the DisplayAlerts.

Thanks for the answer.

Simon


>Don't know if it'll help but you can try

oExcel.DisplayAlerts = .F.

>
>>I am automating Excel and it involves searching and replace text in an Excel file. When the text is not found Excel pops up a wanring dialog telling you that the text cannot be found. Does anyone know how to stop these popup dialogs which are a pain OLE automation?
>>