delete sheet in excel

  • Thread starter Thread starter Bas
  • Start date Start date
B

Bas

I',m trying to delete a named worksheet - what's wrong with this??
xlApp = New Excel.Application()
Dim xWorkbook As Excel.Workbook
Dim PageSht As Excel.Worksheet
xWorkbook = xlApp.Workbooks.Open("Test.xls")
Dim pageWkSht As Excel.Worksheet
pageSht = xWorkbook.Sheets("Page")
pageSht.Delete()

No error is generated and the sheet is NOT deleted
 
Hi,
I',m trying to delete a named worksheet - what's wrong with this??
xlApp = New Excel.Application()
Dim xWorkbook As Excel.Workbook
Dim PageSht As Excel.Worksheet
xWorkbook = xlApp.Workbooks.Open("Test.xls")
Dim pageWkSht As Excel.Worksheet
pageSht = xWorkbook.Sheets("Page")
pageSht.Delete()

No error is generated and the sheet is NOT deleted
Click to expand...

have you tried ..
xWorkbook.Sheets("Page").Delete()
...?

Cheers,
Olaf
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete multiple columns from Excel Spreadsheet from VB.Net application? 3
0x80020003 DISP_E_MEMBERNOTFOUND When working with Excel Spreadsheet 0
Automating Excel from Access 8
RE: Get Excel Worksheet Names for Importing into Access Tables 0
excel 2003 and VB.NET 1
Create Excel file with VBA in Access 7
Save Excel file 2
Opening Excel Worksheet - "Object reference not set to an instance of an object." 2

Back
Top