Delete Sheet in Excel automation

sfosfo Member Posts: 12
Hello,

I'm trying to delete sheets in Excel using automation. I tried to use the .DELETE method of the Worksheet object but it does nothing. If I use it with Excel visible it opens a confirmation dialog ('This sheet might contain data', etc). Would anyone have ran into this problem?

Thanks.

Stephan

Comments

  • martin2008martin2008 Member Posts: 10
    The .Application automation has a property "DisplayAlerts". So xlApplication.DisplayAlerts := FALSE; may be worth a try?
  • Navsyst2Navsyst2 Member Posts: 29
    Hi Stephan,

    did you solve your problem with .delete?

    Regards
    Navsyst
Sign In or Register to comment.