Delete worksheet from an excel - VB.Net
By default, Microsoft Excel provides three worksheets in a workbook. However, it is possible to programmatically add or delete worksheets as required using a VB.Net application. To delete a worksheet, you need to add a reference to the Microsoft.Office.Interop.Excel assembly, which provides the necessary classes and methods for interacting with Excel files.
To access the Excel object model from Visual VB.Net, you need to add the Microsoft Excel 12.0 Object Library to your project. This library provides the necessary classes, properties, and methods to interact with Excel.How to add Excel Library
Delete worksheet from an excel file
In order to delete worksheet from excel file, this VB.Net program open an existing Excel file and select the worksheet and then delete it.
Delete Excel.Worksheet without prompts
To suppress prompts and alert messages while running a macro in Microsoft Excel, you can set the DisplayAlerts property to False. By doing so, Excel will automatically handle any messages that require a response from the user by choosing the default response.
The following VB.Net source code shows how to programmatically delete Worksheets from Workbooks.Full Source VB.NET