suppress the replace-messagebox
 

Hi

i use the excel via OLE-Connection and use the Replace-function

lb_Ret = inv_EXCEL.Selection.Replace( as_Find_String, &
as_Replace_String, &
inv_const.xlPart, &
inv_Const.xlByRows, &
False, &
False, &
False );

but i have one problem - if the source-find-name is not fount the user get
always a error-messagebox from excel - how can i suppress this messagebox??

many thank's for any help
Michael E.

suppress the replace-messagebox
 

but i have one problem - if the source-find-name is not fount the user get
always a error-messagebox from excel - how can i suppress this
messagebox??

Does setting application.DisplayAlerts=False beforehand then reseting
it True afterwards work?

Iain