关于网友提出的“ VC的EXCEL自动化编程的初级问题”问题疑问,本网通过在网上对“ VC的EXCEL自动化编程的初级问题”有关的相关答案进行了整理,供用户进行参考,详细问题解答如下:
问题: VC的EXCEL自动化编程的初级问题
描述: Rang的函数为:
void Range::Sort(const VARIANT& Key1, long Order1, const VARIANT& Key2, const VARIANT& Type, long Order2, const VARIANT& Key3, long Order3, long Header, const VARIANT& OrderCustom, const VARIANT& MatchCase, long Orientation, long SortMethod, const VARIANT& IgnoreControlCharacters, const VARIANT& IgnoreDiacritics, const VARIANT& IgnoreKashida)
{
static BYTE parms[] =
VTS_VARIANT VTS_I4 VTS_VARIANT VTS_VARIANT VTS_I4 VTS_VARIANT VTS_I4 VTS_I4 VTS_VARIANT VTS_VARIANT VTS_I4 VTS_I4 VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x370, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Key1, Order1, &Key2, &Type, Order2, &Key3, Order3, Header, &OrderCustom, &MatchCase, Orientation, SortMethod, &IgnoreControlCharacters, &IgnoreDiacritics, &IgnoreKashida);
}
用EXCEL录制的宏为:
Range("A25:C42").Select
Selection.sort Key1:=Range("B25"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, SortMethod _
:=xlPinYin
请问用sort函数时参数怎么传?VC自动化编程真难呀!!!
以上介绍了“ VC的EXCEL自动化编程的初级问题”的问题解答,希望对有需要的网友有所帮助。
本文网址链接:http://www.codes51.com/itwd/3749348.html