How to Add new sheet to the end?

[Dang.D.Khanh]

Hi,
I have searched a lot of post but still haven't found an answer, the code I use is as follows:

Excel::WorksheetsPtr ws = Worksheets->GetItem(Worksheets->Count); <<-- last worksheet

//Syntax:  IDispatchPtr Sheets::Add ( const _variant_t & Before, const _variant_t & After, 
//                                    const _variant_t & Count, const _variant_t & Type, long lcid );
Worksheets->Add(vtMissing, ws,  <<-- add to last
                            1, vtMissing, (long)Excel::xlWorksheet));

This doc say:

 After	Optional	Variant	An object that specifies the sheet after which the new sheet is added.

but how to convert IDispatchPtr to _variant_t ?

Thanks you!

[VictorN]

...
but how to convert IDispatchPtr to _variant_t ?

Thanks you!

Did you try ( from https://docs.microsoft.com/en-us/cpp...?view=msvc-160 )

_variant_t(
   IDispatch* pDispSrc,
   bool fAddRef = true
) throw( );

[Dang.D.Khanh]

Hi Sir,
Thanks for the reply!
I'm having issues with compiling some other lines of code so I can't run the project.
I will try to compile it and come back soon

[Dang.D.Khanh]

Hi Sir,
This is exactly what I need. My problem is solved !

[VictorN]

Glad you have solved it!