Unanswered: How to bypass confirmation dialogs during VB code execution
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.