Unable to delete a worksheet in a workbook.

[DS]

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

[K Dales]

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
>
>

[DS]

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
> >
> >

[Rowan Drummond]

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
>>>
>>>

[D Santhosh]

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
> >>>
> >>>
>

[Rowan Drummond]

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
>>>>>
>>>>>
>>