Actually, I could just as well provide you with the IDL for IRange::Sort() at
once -- I don't really see why I shouldn't...

Cheers,
/MP

====================================

From Excel 2000's OLB (Excel9.olb):

HRESULT _stdcall Sort(
[in, optional] VARIANT Key1,
[in, optional, defaultvalue(1)] XlSortOrder Order1,
[in, optional] VARIANT Key2,
[in, optional] VARIANT Type,
[in, optional, defaultvalue(1)] XlSortOrder Order2,
[in, optional] VARIANT Key3,
[in, optional, defaultvalue(1)] XlSortOrder Order3,
[in, optional, defaultvalue(2)] XlYesNoGuess Header,
[in, optional] VARIANT OrderCustom,
[in, optional] VARIANT MatchCase,
[in, optional, defaultvalue(2)] XlSortOrientation
Orientation,
[in, optional, defaultvalue(1)] XlSortMethod SortMethod,
[out, retval] VARIANT* RHS);

====================================

....And for your information, here's Excel 2003:

HRESULT _stdcall Sort(
[in, optional] VARIANT Key1,
[in, optional, defaultvalue(1)] XlSortOrder Order1,
[in, optional] VARIANT Key2,
[in, optional] VARIANT Type,
[in, optional, defaultvalue(1)] XlSortOrder Order2,
[in, optional] VARIANT Key3,
[in, optional, defaultvalue(1)] XlSortOrder Order3,
[in, optional, defaultvalue(2)] XlYesNoGuess Header,
[in, optional] VARIANT OrderCustom,
[in, optional] VARIANT MatchCase,
[in, optional, defaultvalue(2)] XlSortOrientation
Orientation,
[in, optional, defaultvalue(1)] XlSortMethod SortMethod,
[in, optional, defaultvalue(0)] XlSortDataOption DataOption1,
[in, optional, defaultvalue(0)] XlSortDataOption DataOption2,
[in, optional, defaultvalue(0)] XlSortDataOption DataOption3,
[out, retval] VARIANT* RHS);

====================================

" wrote:

Hi there. I am having trouble getting a VBA program that I have written
to work on Excel 2000. Basically, I need to know the signature of the
Range.Sort method in Excel 2000. I have looked around a lot and it
seems there is no documentation on Excel 2000, only 2003. The best I
could find was a very helpful document that mentioned that it had
"changed" between 2000 and 2003. Can anyone help, or possibly provide a
link to any documentation that i might have missed?

Thanks in advance
Rohan Shah