Excel_RangeSort

[Dmitry80]

Hi all,

I am trying to use the following function to sort cells in Excel but I don't know what all the parameters should be.Please advise.

HRESULT CVIFUNC Excel_RangeSort (CAObjHandle objectHandle, ERRORINFO *errorInfo,
                                 VARIANT key1, enum ExcelEnum_XlSortOrder order1,
                                 VARIANT key2, VARIANT type,
                                 enum ExcelEnum_XlSortOrder order2, VARIANT key3,
                                 enum ExcelEnum_XlSortOrder order3,
                                 enum ExcelEnum_XlYesNoGuess header,
                                 VARIANT orderCustom, VARIANT matchCase,
                                 enum ExcelEnum_XlSortOrientation orientation,
                                 enum ExcelEnum_XlSortMethod sortMethod,
                                 VARIANT *returnValue)

Thank you,

Dmitry

[Brandon_V]

Dmitry,

This is actually an ActiveX function call directly to Excel. All Excel ActiveX references can be found at msdn.com