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.
|