How do I open a empty workbook with no sheets?

Posted to microsoft.public.excel.programming

ChartsToBe ChartsToBe is offline

external usenet poster

Posts: 6

How do I open a empty workbook with no sheets?

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extra empty workbook opens up when any excel file is open	Anindyo Dutta	Excel Discussion (Misc queries)	1	February 25th 09 01:19 PM
Open workbook to same worksheet and next empty row	inta251 via OfficeKB.com	Excel Worksheet Functions	3	February 24th 07 08:00 PM
Search open sheets in workbook and insert into open sheet	punx77	Excel Discussion (Misc queries)	0	March 6th 06 05:07 PM
How to avoid opening an empty workbook every time I open a file?	Nick Papadakis	Setting up and Configuration of Excel	2	February 12th 06 11:55 AM
Open workbook with x number of sheets	Robert Christie[_3_]	Excel Programming	4	November 11th 04 06:44 PM

All times are GMT +1. The time now is 02:55 PM.

Menu

About Us