In Excel, I do this kind of thing:

dim myWorkbook as workbook
set myworkbook = workbooks.add(1) 'single sheet, same as xlwbatworksheet
myworkbook.worksheets(1).name = "DeleteMeLater"
'do a bunch of stuff
'later
application.displayalerts = false
myworkbook.worksheets("deletemelater").delete
application.displayalerts = true

======
If you always add sheets to the right of worksheets(1), you could drop the
naming stuff and just delete the first worksheet.

ChartsToBe wrote:

I am using this line.

myWorkbook = myExcelApp.Workbooks.Add(Excel.XlWBATemplate.xlWBA TWorksheet);

But, it is giving me an empty sheet to start out with. I have also tried
using Type.missing, but that gives me 3 empty sheets.

--

Dave Peterson