Adding worksheet at the end of workbook

[Ash Jings]

Hi All,

I am working on excel automation using MFC.

I want to add one worksheet at the end of the current workbook.

Currently I am using Worksheets::Add(Before, after, Count,Type) method.
i am passing optional parameter like this:

COleVariant oOleVarOptional(DISP_E_PARAMNOTFOUND,VT_ERROR);

_Worksheet m_oNewSheet = m_oSheets.Add(oOleVarOptional,oOleVarOptional,
oOleVarOptional, oOleVarOptional)

So it is adding the sheet before the current active sheet.

But i am not getting what to pass for "after" in order to add the sheet at
the end.

Can anybody help me regarding this... ?
--
Thanks
Ash Jings
09/09/08

[Ash Jings]

Hey All i found the solution here - http://support.microsoft.com/kb/253501

--
Thanks
Ash Jings

[Engineer]

I need to read data from a Excel file (*.htm) using MFC.
I have been searching without luck for an example.
I wanted to try out the code in the sample you found.
I got: error C2065: '_Application' : undeclared identifier
On the first very first line I copied into my program.
What am I doing wrong?

Thanks in advance

"Ash Jings" <jinagar...@gmail.com> wrote in message
news:7E033092-15EA-43C1...@microsoft.com...

[Drew]

Did you follow the link under References at the bottom of the article?
http://support.microsoft.com/kb/178749/

Drew

"Engineer" <eba...@aol.com> wrote in message
news:e5rZ5gQP...@TK2MSFTNGP06.phx.gbl...