View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JK JK is offline
external usenet poster
 
Posts: 9
Default How do I open a empty workbook with no sheets?

Excel requires that an open workbook has at least one visible
worksheet. Sorry, but I don't see a way to have a workbook without any
worksheets.

If you want an empty vessel for some code, you might want to think
about saving your workbook as an excel add-in. But I'm not really sure
what you need, so I hope you find something that works.

-JK

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.