I'm using VB within DTS to dump data to an Excel sheet. Whenever I do something like Worksheets(1).Delete(), a confirmation dialog comes up. How can I just have the code delete it without asking? This DTS package will be executed via ASP on the web, and I don't want these confirmation dialogs to cause any problems.

Thanks in advance!

At the beginning of the section/code include this line:

Application.DisplayAlerts = False

Then at the end use this line:

Application.DisplayAlerts = True

But if a dialog pops up that wants a yes/no answer... how will the code respond to this? Is yes the default?

Thanks though! This did do the trick. I did xlApp.DisplayAlerts = False (xlApp is the Excel.Application)