Can not delete worksheet

aamirmay

Newbie

Join Date: Jul 2009

Posts: 1

#1: Jul 6 '09

Hi,

I want to delete a worksheet using VB.NET, but fail to do that. Im using the following code:

XLApp = CreateObject("Excel.Application")

XLWorkbook = XLApp.Workbooks.Open(Path)

XLWorksheet = XLWorkbook.Sheets("Sheet1")

XLWorksheet.Activate()

XLWorksheet.Delete()

XLWorkbook.Close()

Please anybody help me!

Regards

« previous question | next question »

Similar Visual Basic .NET bytes

Compare 2 worksheets in Excel and delete rows not contained in both. (answers)
excel process not terminating properly (answers)
Problem with Delete worksheet (answers)
Python crash when trying to generate an Excel worksheet with VBA macros (answers)

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,382 network members.