View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] leonard522@aol.com is offline
external usenet poster
 
Posts: 8
Default How to Delete Excel Sheet without Warning - MFC

Hi ~
I am automating Excel by embedding it in my MFC dialog. I need to
delete an excel chart and I have tried to use the app function
SetDisplayAlerts to FALSE. However, this doesn't work for me. I get
an error message "Unable to Set DisplayAlerts property of Application
Class." I have searched online for hours, and all I have found is that
this may not be available when embedding excel into your program.

So my question is, any ideas on getting this to work, or hiding an
error message? Is there an alternative way to delete a worksheet so
that it won't give an error message?
Please help!!
Jen