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

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

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

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

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

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