Can not delete worksheet

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aamirmay
    New Member
    • Jul 2009
    • 2

    Can not delete worksheet

    Hi,

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


    XLApp = CreateObject("E xcel.Applicatio n")

    XLWorkbook = XLApp.Workbooks .Open(Path)

    XLWorksheet = XLWorkbook.Shee ts("Sheet1")

    XLWorksheet.Act ivate()

    XLWorksheet.Del ete()

    XLWorkbook.Clos e()

    Please anybody help me!

    Regards
Working...