Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to delete a worksheet in a workbook.
I try to delete a worksheet in a workbook using .Delete() method of the
worksheet object. When I run the program nothing happens. Can any one point to me how to delete a worksheet in a workbook using Excel object? Please see below for my working environment. Platform: ..NET 1.1 program references MS Excel 11 library. MS Office 2003. Thanks D. Santhosh |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to delete a worksheet in a workbook.
Nothing happens = not even an error message?
Would need to see code to figure it out. -- - K Dales "DS" wrote: I try to delete a worksheet in a workbook using .Delete() method of the worksheet object. When I run the program nothing happens. Can any one point to me how to delete a worksheet in a workbook using Excel object? Please see below for my working environment. Platform: .NET 1.1 program references MS Excel 11 library. MS Office 2003. Thanks D. Santhosh |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
My code to delete a worksheet
Hi Dales,
Below is my code to delete "Sheet1" worksheet in my workbook. With DirectCast(ThisWorkBook.Sheets("Sheet1"), Excel.Worksheet) .Select() .Delete() End With Thanks D. Santhosh "K Dales" wrote: Nothing happens = not even an error message? Would need to see code to figure it out. -- - K Dales "DS" wrote: I try to delete a worksheet in a workbook using .Delete() method of the worksheet object. When I run the program nothing happens. Can any one point to me how to delete a worksheet in a workbook using Excel object? Please see below for my working environment. Platform: .NET 1.1 program references MS Excel 11 library. MS Office 2003. Thanks D. Santhosh |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
My code to delete a worksheet
Try
ThisWorkbook.Sheets("Sheet1").Delete Hope this helps Rowan DS wrote: Hi Dales, Below is my code to delete "Sheet1" worksheet in my workbook. With DirectCast(ThisWorkBook.Sheets("Sheet1"), Excel.Worksheet) .Select() .Delete() End With Thanks D. Santhosh "K Dales" wrote: Nothing happens = not even an error message? Would need to see code to figure it out. -- - K Dales "DS" wrote: I try to delete a worksheet in a workbook using .Delete() method of the worksheet object. When I run the program nothing happens. Can any one point to me how to delete a worksheet in a workbook using Excel object? Please see below for my working environment. Platform: .NET 1.1 program references MS Excel 11 library. MS Office 2003. Thanks D. Santhosh |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
My code to delete a worksheet
Hi Rowan,
I tried "ThisWorkbook.Sheets("Sheet1").Delete". It does not seem to work. Thanks, D. Santhosh "Rowan Drummond" wrote: Try ThisWorkbook.Sheets("Sheet1").Delete Hope this helps Rowan DS wrote: Hi Dales, Below is my code to delete "Sheet1" worksheet in my workbook. With DirectCast(ThisWorkBook.Sheets("Sheet1"), Excel.Worksheet) .Select() .Delete() End With Thanks D. Santhosh "K Dales" wrote: Nothing happens = not even an error message? Would need to see code to figure it out. -- - K Dales "DS" wrote: I try to delete a worksheet in a workbook using .Delete() method of the worksheet object. When I run the program nothing happens. Can any one point to me how to delete a worksheet in a workbook using Excel object? Please see below for my working environment. Platform: .NET 1.1 program references MS Excel 11 library. MS Office 2003. Thanks D. Santhosh |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
My code to delete a worksheet
In what way does it not work? Are you getting an error message? Is the
sheet still there after you run the code? Etc etc? Regards Rowan D Santhosh wrote: Hi Rowan, I tried "ThisWorkbook.Sheets("Sheet1").Delete". It does not seem to work. Thanks, D. Santhosh "Rowan Drummond" wrote: Try ThisWorkbook.Sheets("Sheet1").Delete Hope this helps Rowan DS wrote: Hi Dales, Below is my code to delete "Sheet1" worksheet in my workbook. With DirectCast(ThisWorkBook.Sheets("Sheet1"), Excel.Worksheet) .Select() .Delete() End With Thanks D. Santhosh "K Dales" wrote: Nothing happens = not even an error message? Would need to see code to figure it out. -- - K Dales "DS" wrote: I try to delete a worksheet in a workbook using .Delete() method of the worksheet object. When I run the program nothing happens. Can any one point to me how to delete a worksheet in a workbook using Excel object? Please see below for my working environment. Platform: .NET 1.1 program references MS Excel 11 library. MS Office 2003. Thanks D. Santhosh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2002: Unable to delete Normal_xyz style inherited from workbook(xy | Excel Discussion (Misc queries) | |||
Unable to delete or insert a worksheet. | Excel Discussion (Misc queries) | |||
in workbook, where is delete worksheet | Excel Worksheet Functions | |||
Unable to delete Active worksheet | Excel Programming | |||
how do I delete a worksheet from my workbook | New Users to Excel |