Forum Discussion

TomY's avatar
TomY
Occasional Contributor
16 years ago

Removing Default Excel Sheets

When creating a new Excel object, it creates 3 default sheets.  How do I remove these extra sheets?



  xclD       = Sys.OleObject("Excel.Application");

  workBkDarwin    = xclD.Workbooks.Add();

 

// remove default sheets



  workSheetEvent = workBkDarwin.Sheets.Add();

  workSheetEvent.Name = "Event";