I am trying to find a particular char in whole EXCEL file and then replacing all
the characters with other char. I am doing this thing programmatically. But if
in excel file there is not such char then as u know excel will give response as
messagebox.
But I want to supress this msgbox programmatically in VB.NET then any one can
tell me how to supress this excel genererated response.
Code for replacing the particular char is as follows.
ExcelAll.Cells.Replace(What:="|", Replacement:="", LookAt:=xlLookAt.xlPart,
SearchOrder:=xlSearchOrder.xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False)