?? excel9.cpp
字號:
&ListArray);
return result;
}
VARIANT _Application::GetOpenFilename(const VARIANT& FileFilter, const VARIANT& FilterIndex, const VARIANT& Title, const VARIANT& ButtonText, const VARIANT& MultiSelect)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x433, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&FileFilter, &FilterIndex, &Title, &ButtonText, &MultiSelect);
return result;
}
VARIANT _Application::GetSaveAsFilename(const VARIANT& InitialFilename, const VARIANT& FileFilter, const VARIANT& FilterIndex, const VARIANT& Title, const VARIANT& ButtonText)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x434, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&InitialFilename, &FileFilter, &FilterIndex, &Title, &ButtonText);
return result;
}
void _Application::Goto(const VARIANT& Reference, const VARIANT& Scroll)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x1db, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Reference, &Scroll);
}
double _Application::GetHeight()
{
double result;
InvokeHelper(0x7b, DISPATCH_PROPERTYGET, VT_R8, (void*)&result, NULL);
return result;
}
void _Application::SetHeight(double newValue)
{
static BYTE parms[] =
VTS_R8;
InvokeHelper(0x7b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
newValue);
}
void _Application::Help(const VARIANT& HelpFile, const VARIANT& HelpContextID)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x162, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&HelpFile, &HelpContextID);
}
BOOL _Application::GetIgnoreRemoteRequests()
{
BOOL result;
InvokeHelper(0x164, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetIgnoreRemoteRequests(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x164, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
double _Application::InchesToPoints(double Inches)
{
double result;
static BYTE parms[] =
VTS_R8;
InvokeHelper(0x43f, DISPATCH_METHOD, VT_R8, (void*)&result, parms,
Inches);
return result;
}
VARIANT _Application::InputBox(LPCTSTR Prompt, const VARIANT& Title, const VARIANT& Default, const VARIANT& Left, const VARIANT& Top, const VARIANT& HelpFile, const VARIANT& HelpContextID, const VARIANT& Type)
{
VARIANT result;
static BYTE parms[] =
VTS_BSTR VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x165, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
Prompt, &Title, &Default, &Left, &Top, &HelpFile, &HelpContextID, &Type);
return result;
}
BOOL _Application::GetInteractive()
{
BOOL result;
InvokeHelper(0x169, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetInteractive(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x169, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
VARIANT _Application::GetInternational(const VARIANT& Index)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x16a, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, parms,
&Index);
return result;
}
BOOL _Application::GetIteration()
{
BOOL result;
InvokeHelper(0x16b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetIteration(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x16b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
double _Application::GetLeft()
{
double result;
InvokeHelper(0x7f, DISPATCH_PROPERTYGET, VT_R8, (void*)&result, NULL);
return result;
}
void _Application::SetLeft(double newValue)
{
static BYTE parms[] =
VTS_R8;
InvokeHelper(0x7f, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
newValue);
}
CString _Application::GetLibraryPath()
{
CString result;
InvokeHelper(0x16e, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Application::MacroOptions(const VARIANT& Macro, const VARIANT& Description, const VARIANT& HasMenu, const VARIANT& MenuText, const VARIANT& HasShortcutKey, const VARIANT& ShortcutKey, const VARIANT& Category, const VARIANT& StatusBar, const VARIANT& HelpContextID, const VARIANT& HelpFile)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x46f, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Macro, &Description, &HasMenu, &MenuText, &HasShortcutKey, &ShortcutKey, &Category, &StatusBar, &HelpContextID, &HelpFile);
}
void _Application::MailLogoff()
{
InvokeHelper(0x3b1, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void _Application::MailLogon(const VARIANT& Name, const VARIANT& Password, const VARIANT& DownloadNewMail)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x3af, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Name, &Password, &DownloadNewMail);
}
VARIANT _Application::GetMailSession()
{
VARIANT result;
InvokeHelper(0x3ae, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
long _Application::GetMailSystem()
{
long result;
InvokeHelper(0x3cb, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
BOOL _Application::GetMathCoprocessorAvailable()
{
BOOL result;
InvokeHelper(0x16f, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
double _Application::GetMaxChange()
{
double result;
InvokeHelper(0x170, DISPATCH_PROPERTYGET, VT_R8, (void*)&result, NULL);
return result;
}
void _Application::SetMaxChange(double newValue)
{
static BYTE parms[] =
VTS_R8;
InvokeHelper(0x170, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
newValue);
}
long _Application::GetMaxIterations()
{
long result;
InvokeHelper(0x171, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetMaxIterations(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x171, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
long _Application::GetMemoryFree()
{
long result;
InvokeHelper(0x172, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
long _Application::GetMemoryTotal()
{
long result;
InvokeHelper(0x173, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
long _Application::GetMemoryUsed()
{
long result;
InvokeHelper(0x174, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
BOOL _Application::GetMouseAvailable()
{
BOOL result;
InvokeHelper(0x175, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL _Application::GetMoveAfterReturn()
{
BOOL result;
InvokeHelper(0x176, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetMoveAfterReturn(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x176, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Application::GetMoveAfterReturnDirection()
{
long result;
InvokeHelper(0x478, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetMoveAfterReturnDirection(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x478, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
LPDISPATCH _Application::GetRecentFiles()
{
LPDISPATCH result;
InvokeHelper(0x4b2, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
CString _Application::GetName()
{
CString result;
InvokeHelper(0x6e, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::NextLetter()
{
LPDISPATCH result;
InvokeHelper(0x3cc, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, NULL);
return result;
}
CString _Application::GetNetworkTemplatesPath()
{
CString result;
InvokeHelper(0x184, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetODBCErrors()
{
LPDISPATCH result;
InvokeHelper(0x4b3, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Application::GetODBCTimeout()
{
long result;
InvokeHelper(0x4b4, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetODBCTimeout(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x4b4, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
void _Application::OnKey(LPCTSTR Key, const VARIANT& Procedure)
{
static BYTE parms[] =
VTS_BSTR VTS_VARIANT;
InvokeHelper(0x272, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Key, &Procedure);
}
void _Application::OnRepeat(LPCTSTR Text, LPCTSTR Procedure)
{
static BYTE parms[] =
VTS_BSTR VTS_BSTR;
InvokeHelper(0x301, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Text, Procedure);
}
void _Application::OnTime(const VARIANT& EarliestTime, LPCTSTR Procedure, const VARIANT& LatestTime, const VARIANT& Schedule)
{
static BYTE parms[] =
VTS_VARIANT VTS_BSTR VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x270, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&EarliestTime, Procedure, &LatestTime, &Schedule);
}
void _Application::OnUndo(LPCTSTR Text, LPCTSTR Procedure)
{
static BYTE parms[] =
VTS_BSTR VTS_BSTR;
InvokeHelper(0x302, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Text, Procedure);
}
CString _Application::GetOnWindow()
{
CString result;
InvokeHelper(0x26f, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Application::SetOnWindow(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x26f, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
CString _Application::GetOperatingSystem()
{
CString result;
InvokeHelper(0x177, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
CString _Application::GetOrganizationName()
{
CString result;
InvokeHelper(0x178, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
CString _Application::GetPath()
{
CString result;
InvokeHelper(0x123, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
CString _Application::GetPathSeparator()
{
CString result;
InvokeHelper(0x179, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
VARIANT _Application::GetPreviousSelections(const VARIANT& Index)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x17a, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, parms,
&Index);
return result;
}
BOOL _Application::GetPivotTableSelection()
{
BOOL result;
InvokeHelper(0x4b5, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetPivotTableSelection(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x4b5, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetPromptForSummaryInfo()
{
BOOL result;
InvokeHelper(0x426, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetPromptForSummaryInfo(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x426, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Application::Quit()
{
InvokeHelper(0x12e, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void _Application::RecordMacro(const VARIANT& BasicCode, const VARIANT& XlmCode)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x305, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&BasicCode, &XlmCode);
}
BOOL _Application::GetRecordRelative()
{
BOOL result;
InvokeHelper(0x17b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
long _Application::GetReferenceStyle()
{
long result;
InvokeHelper(0x17c, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetReferenceStyle(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x17c, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
VARIANT _Application::GetRegisteredFunctions(const VARIANT& Index1, const VARIANT& Index2)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x307, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, parms,
&Index1, &Index2);
return result;
}
BOOL _Application::RegisterXLL(LPCTSTR Filename)
{
BOOL result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x1e, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
Filename);
return result;
}
void _Application::Repeat()
{
InvokeHelper(0x12d, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -