Delete Excel Sheet 1

[Rougy]

Hi,

I need to delete an excel sheet.

xlapp.sheets(1).delete (something goes here I think)

does anybody know the command for either dodging, disabling, or answering the excel dialog box that pops up and asks to confirm the delete?

Thanks,

Rougy -----
The death of dogma is the birth of reason.

 

[Rougy]

Found it.

XLApp.DisplayAlerts = False
XLApp.Sheets(1).Delete
XLApp.DisplayAlerts = True -----
The death of dogma is the birth of reason.

 

[Debeast]

Thanks for that really helped me out too