Delete method gives confirmation dialog box

[VogonPoet]

I have an Access(2000) program that is doing some manipulation to Excel(2000) workbooks. When I execute the following command, I get a dialog box asking me to confirm the deleteion:

objWkbk.Worksheets(intCnt).Delete

How can I temporarily disable the dialog box asking me to confirm the delete?

 

[SyedAqif]

Hi

I am not sure whats ur main problem is . You want to disable that code or u want to supress the system generated warning. If u want to supress system generated warning than just add

DoCmd.SetWarnings False

At the end of ur code set the warnings to true by writing

DoCmd.SetWarnings True

Hope this will help u

Cheers!
Aqif