Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How to Supress Excel Generated Messages

  Asked By: Daisy    Date: Aug 27    Category: MS Office    Views: 589
  

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)

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Finn Jones     Answered On: Aug 27

Something on the lines of:

Application.DisplayAlerts = False

then later switch them back on again:

Application.DisplayAlerts = True

 
Answer #2    Answered By: Ramon Davis     Answered On: Aug 27

Due to just ur single line code, now no need to write code  for replacing  all
the required char  by some other characters.

 
Didn't find what you were looking for? Find more on How to Supress Excel Generated Messages Or get search suggestion and latest updates.




Tagged: