How to delete one sheet in excel workbook?

[Gak]

Hi,

I am using Excel in my application want to keep one Excel as ideal ..I.e. each time when application will open All I/p will come from that ideal excel sheet

so what I am doing is I am copying that ideal excel sheet in another sheet(dummy) and then using that dummy sheet m running my application.

But problem is each time I run VI to copy excel,it does not overwrite on same sheet,but creates new sheet.and application becomes slow. I am attaching VI with this ..Please give me solution on this.

Thank you

GAK

[smercurio_fc · Accepted solution]

You are using the Worksheet.Copy function. By design (and by documentation), that function will create a new worksheet. If you want to replace the contents of a worksheet you have to copy the cells in the source worksheet and write to the target worksheet. For this you would use the Range object.

You may want to peruse the Excel thread for lots of Excel examples.