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

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.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Macca" wrote in message
...
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

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 :

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.

True... Why didn't I think of that? ;) Sometimes I do things the hard way

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"keepITcool" wrote in message
...

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 :

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.

Thnaks for the replies.

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

Cheers
Macca


"Rob van Gelder" wrote:

True... Why didn't I think of that? ;) Sometimes I do things the hard way

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"keepITcool" wrote in message
...

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 :

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.