Creating Workbook with 2 worksheets

[Guest]

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

 

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

 

[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 :

 

[Rob van Gelder]

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

 

[Guest]

Thnaks for the replies.

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

Cheers
Macca