Application::DisplayAlerts not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am calling the Range::Replace(..) function in Excel by an automating app. I would like to not have a dialog box come up if no matches are found for my search object. I tried setting DisplayAlerts == false, but this doesn't seem to have any effect. Any ideas??

thanks,

_howard

BTW -- writing in C# using office 2003 PIAs
 
In some versions of Excel, sending a DisplayAlerts command from external of
Excel, only is applied for that command - I believe this was fixed in xl2000
SR1. The recommended solution is to run a macro internal to excel where the
display alerts is set and the command executed.

Can't say if this is your problem, but may be.

--
Regards,
Tom Ogilvy

Howard Dierking said:
I am calling the Range::Replace(..) function in Excel by an automating
Click to expand...
app. I would like to not have a dialog box come up if no matches are found
for my search object. I tried setting DisplayAlerts == false, but this
doesn't seem to have any effect. Any ideas??
 
Howard Dierking said:
I tried setting DisplayAlerts == false, but this doesn't seem to have
any effect. Any ideas??
Click to expand...

In C#, isn't DisplayAlerts == false a comparison, not an assignment?!

--
 
Back
Top