Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To show a messagebox | Excel Discussion (Misc queries) | |||
Printing messagebox | Excel Discussion (Misc queries) | |||
messagebox problem | Excel Programming | |||
Working around a messagebox | Excel Programming | |||
within a macro how can I suppress the warning pop "A file named xxxx.xls already exists in this location. Do you want to replace it?" | Excel Programming |