View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Application::DisplayAlerts not working

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" wrote in message
...
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