Delte sheets in Excel from Access

[Guest]

Hi
I have the code to delete sheets in excel however I get a warning message
which I would like to have turned off so that it just performs the deletion.

Any ideas would be appreciated.

I have tried docmd.setwarnings = false but this doesn't do anything and I
have also tried applicaiton.displayalerts = false but this doesn't work
either.

Thanks
Noemi

 

[Guest]

Try this:

excel.application.displayalerts = false