Creating Workbook with 2 worksheets

M

Macca

Hi,

I am using Automation with VC++ 6 to create and write to a spreadsheet.

I use the following to create it :-

COleVariant
covTrue((short)TRUE),
covFalse((short)FALSE),
covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);


// Start Excel and get Application object.

if(!m_objApp.CreateDispatch("Excel.Application"))
{
AfxMessageBox("Couldn't start Excel and get Application object.");
//return;
}

m_objBooks = m_objApp.GetWorkbooks();
m_objBook = m_objBooks.Add (covOptional);

This code creates a workbook with 3 work sheets. Is it possible to define
how many worksheets are created when i first create my workbook? e.g 2
worksheets?

Thanks In Advance
Macca
 
R

Rob van Gelder

There is a setting:
eg.
Application.SheetsInNewWorkbook = 2
(That's VBA, not C++)

However, this is a preference for the user which is saved as Excel is
closed.
When the user next opens Excel, they'll get as many sheets as you last set.

If I want to create a book with 2 sheets then I write code to add sheets if
they are missing, remove sheets if there are too many.
 
K

keepITcool

or do this?..

dim lSNW&
lSNW = Application.SheetsInNewWorkbook
Application.SheetsInNewWorkbook = 2
workbooks.add
Application.SheetsInNewWorkbook= lSNW





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Rob van Gelder wrote :
 
M

Macca

Thnaks for the replies.

Do you know how i add/remove using VC++ rather than VBA?

Cheers
Macca
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top