27 Workbooks(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
41 LPDISPATCH
GetItem(
const VARIANT& Index);
43 LPDISPATCH
Open(LPCTSTR Filename,
const VARIANT& UpdateLinks,
const VARIANT& ReadOnly,
const VARIANT& Format,
const VARIANT& Password,
const VARIANT& WriteResPassword,
const VARIANT& IgnoreReadOnlyRecommended,
const VARIANT& Origin,
44 const VARIANT& Delimiter,
const VARIANT& Editable,
const VARIANT& Notify,
const VARIANT& Converter,
const VARIANT& AddToMru);
45 void OpenText(LPCTSTR Filename,
const VARIANT& Origin,
const VARIANT& StartRow,
const VARIANT& DataType,
long TextQualifier,
const VARIANT& ConsecutiveDelimiter,
const VARIANT& Tab,
const VARIANT& Semicolon,
const VARIANT& Comma,
46 const VARIANT& Space,
const VARIANT& Other,
const VARIANT& OtherChar,
const VARIANT& FieldInfo,
const VARIANT& TextVisualLayout);
56 _Application(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
84 void DDEPoke(
long Channel,
const VARIANT& Item,
const VARIANT& Data);
87 VARIANT
Evaluate(
const VARIANT& Name);
90 LPDISPATCH
Intersect(LPDISPATCH Arg1, LPDISPATCH Arg2,
const VARIANT& Arg3,
const VARIANT& Arg4,
const VARIANT& Arg5,
const VARIANT& Arg6,
const VARIANT& Arg7,
const VARIANT& Arg8,
const VARIANT& Arg9,
const VARIANT& Arg10,
91 const VARIANT& Arg11,
const VARIANT& Arg12,
const VARIANT& Arg13,
const VARIANT& Arg14,
const VARIANT& Arg15,
const VARIANT& Arg16,
const VARIANT& Arg17,
const VARIANT& Arg18,
const VARIANT& Arg19,
const VARIANT& Arg20,
92 const VARIANT& Arg21,
const VARIANT& Arg22,
const VARIANT& Arg23,
const VARIANT& Arg24,
const VARIANT& Arg25,
const VARIANT& Arg26,
const VARIANT& Arg27,
const VARIANT& Arg28,
const VARIANT& Arg29,
const VARIANT& Arg30);
94 LPDISPATCH
GetRange(
const VARIANT& Cell1,
const VARIANT& Cell2);
96 VARIANT
Run(
const VARIANT& Macro,
const VARIANT& Arg1,
const VARIANT& Arg2,
const VARIANT& Arg3,
const VARIANT& Arg4,
const VARIANT& Arg5,
const VARIANT& Arg6,
const VARIANT& Arg7,
const VARIANT& Arg8,
const VARIANT& Arg9,
97 const VARIANT& Arg10,
const VARIANT& Arg11,
const VARIANT& Arg12,
const VARIANT& Arg13,
const VARIANT& Arg14,
const VARIANT& Arg15,
const VARIANT& Arg16,
const VARIANT& Arg17,
const VARIANT& Arg18,
const VARIANT& Arg19,
98 const VARIANT& Arg20,
const VARIANT& Arg21,
const VARIANT& Arg22,
const VARIANT& Arg23,
const VARIANT& Arg24,
const VARIANT& Arg25,
const VARIANT& Arg26,
const VARIANT& Arg27,
const VARIANT& Arg28,
const VARIANT& Arg29,
99 const VARIANT& Arg30);
100 VARIANT
_Run2(
const VARIANT& Macro,
const VARIANT& Arg1,
const VARIANT& Arg2,
const VARIANT& Arg3,
const VARIANT& Arg4,
const VARIANT& Arg5,
const VARIANT& Arg6,
const VARIANT& Arg7,
const VARIANT& Arg8,
const VARIANT& Arg9,
101 const VARIANT& Arg10,
const VARIANT& Arg11,
const VARIANT& Arg12,
const VARIANT& Arg13,
const VARIANT& Arg14,
const VARIANT& Arg15,
const VARIANT& Arg16,
const VARIANT& Arg17,
const VARIANT& Arg18,
const VARIANT& Arg19,
102 const VARIANT& Arg20,
const VARIANT& Arg21,
const VARIANT& Arg22,
const VARIANT& Arg23,
const VARIANT& Arg24,
const VARIANT& Arg25,
const VARIANT& Arg26,
const VARIANT& Arg27,
const VARIANT& Arg28,
const VARIANT& Arg29,
103 const VARIANT& Arg30);
105 void SendKeys(
const VARIANT& Keys,
const VARIANT&
Wait);
108 LPDISPATCH
Union(LPDISPATCH Arg1, LPDISPATCH Arg2,
const VARIANT& Arg3,
const VARIANT& Arg4,
const VARIANT& Arg5,
const VARIANT& Arg6,
const VARIANT& Arg7,
const VARIANT& Arg8,
const VARIANT& Arg9,
const VARIANT& Arg10,
const VARIANT& Arg11,
109 const VARIANT& Arg12,
const VARIANT& Arg13,
const VARIANT& Arg14,
const VARIANT& Arg15,
const VARIANT& Arg16,
const VARIANT& Arg17,
const VARIANT& Arg18,
const VARIANT& Arg19,
const VARIANT& Arg20,
const VARIANT& Arg21,
110 const VARIANT& Arg22,
const VARIANT& Arg23,
const VARIANT& Arg24,
const VARIANT& Arg25,
const VARIANT& Arg26,
const VARIANT& Arg27,
const VARIANT& Arg28,
const VARIANT& Arg29,
const VARIANT& Arg30);
118 void AddChartAutoFormat(
const VARIANT& Chart, LPCTSTR Name,
const VARIANT& Description);
119 void AddCustomList(
const VARIANT& ListArray,
const VARIANT& ByRow);
142 BOOL CheckSpelling(LPCTSTR Word,
const VARIANT& CustomDictionary,
const VARIANT& IgnoreUppercase);
150 VARIANT
ConvertFormula(
const VARIANT& Formula,
long FromReferenceStyle,
const VARIANT& ToReferenceStyle,
const VARIANT& ToAbsolute,
const VARIANT& RelativeTo);
203 VARIANT
GetOpenFilename(
const VARIANT& FileFilter,
const VARIANT& FilterIndex,
const VARIANT& Title,
const VARIANT& ButtonText,
const VARIANT& MultiSelect);
204 VARIANT
GetSaveAsFilename(
const VARIANT& InitialFilename,
const VARIANT& FileFilter,
const VARIANT& FilterIndex,
const VARIANT& Title,
const VARIANT& ButtonText);
205 void Goto(
const VARIANT& Reference,
const VARIANT& Scroll);
208 void Help(
const VARIANT& HelpFile,
const VARIANT& HelpContextID);
212 VARIANT
InputBox(LPCTSTR Prompt,
const VARIANT& Title,
const VARIANT& Default,
const VARIANT& Left,
const VARIANT& Top,
const VARIANT& HelpFile,
const VARIANT& HelpContextID,
const VARIANT& Type);
221 void 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,
222 const VARIANT& HelpContextID,
const VARIANT& HelpFile);
224 void MailLogon(
const VARIANT& Name,
const VARIANT& Password,
const VARIANT& DownloadNewMail);
247 void OnKey(LPCTSTR Key,
const VARIANT& Procedure);
248 void OnRepeat(LPCTSTR Text, LPCTSTR Procedure);
249 void OnTime(
const VARIANT& EarliestTime, LPCTSTR Procedure,
const VARIANT& LatestTime,
const VARIANT& Schedule);
250 void OnUndo(LPCTSTR Text, LPCTSTR Procedure);
263 void RecordMacro(
const VARIANT& BasicCode,
const VARIANT& XlmCode);
275 void SetDefaultChart(
const VARIANT& FormatName,
const VARIANT& Gallery);
293 void SetTop(
double newValue);
315 void Wait(
const VARIANT& Time);
339 _Workbook(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
362 void ChangeFileAccess(
long Mode,
const VARIANT& WritePassword,
const VARIANT& Notify);
363 void ChangeLink(LPCTSTR Name, LPCTSTR NewName,
long Type);
365 void Close(
const VARIANT& SaveChanges,
const VARIANT& Filename,
const VARIANT& RouteWorkbook);
370 void SetColors(
const VARIANT& Index,
const VARIANT& newValue);
391 VARIANT
LinkInfo(LPCTSTR Name,
long LinkInfo,
const VARIANT& Type,
const VARIANT& EditionRef);
399 void OpenLinks(LPCTSTR Name,
const VARIANT& ReadOnly,
const VARIANT& Type);
406 void Post(
const VARIANT& DestName);
409 void PrintOut(
const VARIANT& From,
const VARIANT& To,
const VARIANT& Copies,
const VARIANT& Preview,
const VARIANT& ActivePrinter,
const VARIANT& PrintToFile,
const VARIANT& Collate);
411 void Protect(
const VARIANT& Password,
const VARIANT& Structure,
const VARIANT& Windows);
412 void ProtectSharing(
const VARIANT& Filename,
const VARIANT& Password,
const VARIANT& WriteResPassword,
const VARIANT& ReadOnlyRecommended,
const VARIANT& CreateBackup,
const VARIANT& SharingPassword);
427 void SaveAs(
const VARIANT& Filename,
const VARIANT& FileFormat,
const VARIANT& Password,
const VARIANT& WriteResPassword,
const VARIANT& ReadOnlyRecommended,
const VARIANT& CreateBackup,
long AccessMode,
const VARIANT& ConflictResolution,
428 const VARIANT& AddToMru,
const VARIANT& TextCodepage,
const VARIANT& TextVisualLayout);
434 void SendMail(
const VARIANT& Recipients,
const VARIANT& Subject,
const VARIANT& ReturnReceipt);
435 void SendMailer(
const VARIANT& FileFormat,
long Priority);
444 void UpdateLink(
const VARIANT& Name,
const VARIANT& Type);
465 void AcceptAllChanges(
const VARIANT& When,
const VARIANT& Who,
const VARIANT& Where);
466 void RejectAllChanges(
const VARIANT& When,
const VARIANT& Who,
const VARIANT& Where);
469 void FollowHyperlink(LPCTSTR Address,
const VARIANT& SubAddress,
const VARIANT&
NewWindow,
const VARIANT& AddHistory,
const VARIANT& ExtraInfo,
const VARIANT& Method,
const VARIANT& HeaderInfo);
480 _Worksheet(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
492 void Copy(
const VARIANT& Before,
const VARIANT& After);
498 void Move(
const VARIANT& Before,
const VARIANT& After);
500 void SetName(LPCTSTR lpszNewValue);
504 void PrintOut(
const VARIANT& From,
const VARIANT& To,
const VARIANT& Copies,
const VARIANT& Preview,
const VARIANT& ActivePrinter,
const VARIANT& PrintToFile,
const VARIANT& Collate);
506 void Protect(
const VARIANT& Password,
const VARIANT& DrawingObjects,
const VARIANT& Contents,
const VARIANT&
Scenarios,
const VARIANT& UserInterfaceOnly);
511 void SaveAs(LPCTSTR Filename,
const VARIANT& FileFormat,
const VARIANT& Password,
const VARIANT& WriteResPassword,
const VARIANT& ReadOnlyRecommended,
const VARIANT& CreateBackup,
const VARIANT& AddToMru,
const VARIANT& TextCodepage,
512 const VARIANT& TextVisualLayout);
513 void Select(
const VARIANT& Replace);
528 void CheckSpelling(
const VARIANT& CustomDictionary,
const VARIANT& IgnoreUppercase,
const VARIANT& AlwaysSuggest,
const VARIANT& IgnoreInitialAlefHamza,
const VARIANT& IgnoreFinalYaa,
const VARIANT& SpellScript);
543 VARIANT
Evaluate(
const VARIANT& Name);
550 void Paste(
const VARIANT& Destination,
const VARIANT& Link);
551 void PasteSpecial(
const VARIANT& Format,
const VARIANT& Link,
const VARIANT& DisplayAsIcon,
const VARIANT& IconFileName,
const VARIANT& IconIndex,
const VARIANT& IconLabel);
553 LPDISPATCH
PivotTableWizard(
const VARIANT& SourceType,
const VARIANT& SourceData,
const VARIANT& TableDestination,
const VARIANT& TableName,
const VARIANT& RowGrand,
const VARIANT& ColumnGrand,
const VARIANT& SaveData,
554 const VARIANT& HasAutoFormat,
const VARIANT& AutoPage,
const VARIANT& Reserved,
const VARIANT& BackgroundQuery,
const VARIANT& OptimizeCache,
const VARIANT& PageFieldOrder,
const VARIANT& PageFieldWrapCount,
const VARIANT& ReadData,
556 LPDISPATCH
GetRange(
const VARIANT& Cell1,
const VARIANT& Cell2);
558 LPDISPATCH
Scenarios(
const VARIANT& Index);
584class Range :
public COleDispatchDriver
588 Range(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
589 Range(
const Range& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
602 CString
GetAddress(
const VARIANT& RowAbsolute,
const VARIANT& ColumnAbsolute,
long ReferenceStyle,
const VARIANT& External,
const VARIANT& RelativeTo);
603 CString
GetAddressLocal(
const VARIANT& RowAbsolute,
const VARIANT& ColumnAbsolute,
long ReferenceStyle,
const VARIANT& External,
const VARIANT& RelativeTo);
604 void AdvancedFilter(
long Action,
const VARIANT& CriteriaRange,
const VARIANT& CopyToRange,
const VARIANT& Unique);
605 void ApplyNames(
const VARIANT& Names,
const VARIANT& IgnoreRelativeAbsolute,
const VARIANT& UseRowColumnNames,
const VARIANT& OmitColumn,
const VARIANT& OmitRow,
long Order,
const VARIANT& AppendLast);
609 void AutoFill(LPDISPATCH Destination,
long Type);
610 void AutoFilter(
const VARIANT& Field,
const VARIANT& Criteria1,
long Operator,
const VARIANT& Criteria2,
const VARIANT& VisibleDropDown);
612 void AutoFormat(
long Format,
const VARIANT& Number,
const VARIANT& Font,
const VARIANT& Alignment,
const VARIANT&
Border,
const VARIANT& Pattern,
const VARIANT& Width);
614 void BorderAround(
const VARIANT& LineStyle,
long Weight,
long ColorIndex,
const VARIANT&
Color);
618 LPDISPATCH
GetCharacters(
const VARIANT& Start,
const VARIANT& Length);
619 void CheckSpelling(
const VARIANT& CustomDictionary,
const VARIANT& IgnoreUppercase,
const VARIANT& AlwaysSuggest,
const VARIANT& IgnoreInitialAlefHamza,
const VARIANT& IgnoreFinalYaa,
const VARIANT& SpellScript);
630 void Consolidate(
const VARIANT& Sources,
const VARIANT& Function,
const VARIANT& TopRow,
const VARIANT& LeftColumn,
const VARIANT& CreateLinks);
631 void Copy(
const VARIANT& Destination);
632 long CopyFromRecordset(LPUNKNOWN Data,
const VARIANT& MaxRows,
const VARIANT& MaxColumns);
635 void CreateNames(
const VARIANT& Top,
const VARIANT& Left,
const VARIANT& Bottom,
const VARIANT& Right);
636 void CreatePublisher(
const VARIANT& Edition,
long Appearance,
const VARIANT& ContainsPICT,
const VARIANT& ContainsBIFF,
const VARIANT& ContainsRTF,
const VARIANT& ContainsVALU);
639 void Cut(
const VARIANT& Destination);
640 void DataSeries(
const VARIANT& Rowcol,
long Type,
long Date,
const VARIANT& Step,
const VARIANT& Stop,
const VARIANT& Trend);
641 VARIANT
Get_Default(
const VARIANT& RowIndex,
const VARIANT& ColumnIndex);
642 void Set_Default(
const VARIANT& RowIndex,
const VARIANT& ColumnIndex,
const VARIANT& newValue);
643 void Delete(
const VARIANT& Shift);
648 VARIANT
EditionOptions(
long Type,
long Option,
const VARIANT& Name,
const VARIANT& Reference,
long Appearance,
long ChartSize,
const VARIANT& Format);
649 LPDISPATCH
GetEnd(
long Direction);
656 LPDISPATCH
Find(
const VARIANT& What,
const VARIANT& After,
const VARIANT& LookIn,
const VARIANT& LookAt,
const VARIANT& SearchOrder,
long SearchDirection,
const VARIANT& MatchCase,
const VARIANT& MatchByte,
657 const VARIANT& MatchControlCharacters,
const VARIANT& MatchDiacritics,
const VARIANT& MatchKashida,
const VARIANT& MatchAlefHamza);
658 LPDISPATCH
FindNext(
const VARIANT& After);
676 BOOL GoalSeek(
const VARIANT& Goal, LPDISPATCH ChangingCell);
677 VARIANT
Group(
const VARIANT& Start,
const VARIANT& End,
const VARIANT& By,
const VARIANT& Periods);
688 void Insert(
const VARIANT& Shift);
690 VARIANT
GetItem(
const VARIANT& RowIndex,
const VARIANT& ColumnIndex);
691 void SetItem(
const VARIANT& RowIndex,
const VARIANT& ColumnIndex,
const VARIANT& newValue);
699 void Merge(
const VARIANT& Across);
705 void SetName(
const VARIANT& newValue);
706 void NavigateArrow(
const VARIANT& TowardPrecedent,
const VARIANT& ArrowNumber,
const VARIANT& LinkNumber);
709 CString
NoteText(
const VARIANT& Text,
const VARIANT& Start,
const VARIANT& Length);
714 LPDISPATCH
GetOffset(
const VARIANT& RowOffset,
const VARIANT& ColumnOffset);
721 void Parse(
const VARIANT& ParseLine,
const VARIANT& Destination);
722 void PasteSpecial(
long Paste,
long Operation,
const VARIANT& SkipBlanks,
const VARIANT& Transpose);
729 void PrintOut(
const VARIANT& From,
const VARIANT& To,
const VARIANT& Copies,
const VARIANT& Preview,
const VARIANT& ActivePrinter,
const VARIANT& PrintToFile,
const VARIANT& Collate);
732 LPDISPATCH
GetRange(
const VARIANT& Cell1,
const VARIANT& Cell2);
734 BOOL Replace(
const VARIANT& What,
const VARIANT& Replacement,
const VARIANT& LookAt,
const VARIANT& SearchOrder,
const VARIANT& MatchCase,
const VARIANT& MatchByte,
const VARIANT& MatchControlCharacters,
const VARIANT& MatchDiacritics,
735 const VARIANT& MatchKashida,
const VARIANT& MatchAlefHamza);
736 LPDISPATCH
GetResize(
const VARIANT& RowSize,
const VARIANT& ColumnSize);
742 VARIANT
Run(
const VARIANT& Arg1,
const VARIANT& Arg2,
const VARIANT& Arg3,
const VARIANT& Arg4,
const VARIANT& Arg5,
const VARIANT& Arg6,
const VARIANT& Arg7,
const VARIANT& Arg8,
const VARIANT& Arg9,
const VARIANT& Arg10,
743 const VARIANT& Arg11,
const VARIANT& Arg12,
const VARIANT& Arg13,
const VARIANT& Arg14,
const VARIANT& Arg15,
const VARIANT& Arg16,
const VARIANT& Arg17,
const VARIANT& Arg18,
const VARIANT& Arg19,
const VARIANT& Arg20,
744 const VARIANT& Arg21,
const VARIANT& Arg22,
const VARIANT& Arg23,
const VARIANT& Arg24,
const VARIANT& Arg25,
const VARIANT& Arg26,
const VARIANT& Arg27,
const VARIANT& Arg28,
const VARIANT& Arg29,
const VARIANT& Arg30);
754 void 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,
755 const VARIANT& IgnoreControlCharacters,
const VARIANT& IgnoreDiacritics,
const VARIANT& IgnoreKashida);
756 void SortSpecial(
long SortMethod,
const VARIANT& Key1,
long Order1,
const VARIANT& Type,
const VARIANT& Key2,
long Order2,
const VARIANT& Key3,
long Order3,
long Header,
const VARIANT& OrderCustom,
const VARIANT& MatchCase,
long Orientation);
758 LPDISPATCH
SpecialCells(
long Type,
const VARIANT& Value);
760 void SetStyle(
const VARIANT& newValue);
762 void Subtotal(
long GroupBy,
long Function,
const VARIANT& TotalList,
const VARIANT&
Replace,
const VARIANT& PageBreaks,
long SummaryBelowData);
764 void Table(
const VARIANT& RowInput,
const VARIANT& ColumnInput);
766 void TextToColumns(
const VARIANT& Destination,
long DataType,
long TextQualifier,
const VARIANT& ConsecutiveDelimiter,
const VARIANT& Tab,
const VARIANT& Semicolon,
const VARIANT& Comma,
const VARIANT& Space,
const VARIANT& Other,
767 const VARIANT& OtherChar,
const VARIANT& FieldInfo);
776 void SetValue(
const VARIANT& newValue);
801 Border(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
813 void SetColor(
const VARIANT& newValue);
828 Borders(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
840 void SetColor(
const VARIANT& newValue);
844 LPDISPATCH
GetItem(
long Index);
849 void SetValue(
const VARIANT& newValue);
861 Interior(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
873 void SetColor(
const VARIANT& newValue);
void SetDisplayStatusBar(BOOL bNewValue)
BOOL GetEnableAutoComplete()
BOOL GetDisplayNoteIndicator()
void SetDefaultSaveFormat(long nNewValue)
void SetDisplayFormulaBar(BOOL bNewValue)
LPDISPATCH GetExcel4MacroSheets()
void SetMaxChange(double newValue)
void SetScreenUpdating(BOOL bNewValue)
LPDISPATCH GetAutoCorrect()
LPDISPATCH GetActiveChart()
void SetDefaultFilePath(LPCTSTR lpszNewValue)
void SetDefaultSheetDirection(long nNewValue)
void SetShowChartTipValues(BOOL bNewValue)
LPDISPATCH GetActiveCell()
VARIANT GetCustomListContents(long ListNum)
BOOL GetShowChartTipNames()
void SetDataEntryMode(long nNewValue)
void SetTransitionMenuKeyAction(long nNewValue)
BOOL GetTransitionNavigKeys()
LPDISPATCH GetWorkbooks()
long GetCustomListCount()
CString GetTemplatesPath()
void SetTransitionMenuKey(LPCTSTR lpszNewValue)
void 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)
BOOL GetEditDirectlyInCell()
void SetShowChartTipNames(BOOL bNewValue)
void SetAskToUpdateLinks(BOOL bNewValue)
long GetDDEAppReturnCode()
VARIANT ExecuteExcel4Macro(LPCTSTR String)
VARIANT GetFileConverters(const VARIANT &Index1, const VARIANT &Index2)
VARIANT GetCaller(const VARIANT &Index)
VARIANT GetClipboardFormats(const VARIANT &Index)
BOOL GetConstrainNumeric()
LPDISPATCH GetWorksheetFunction()
long DDEInitiate(LPCTSTR App, LPCTSTR Topic)
VARIANT ConvertFormula(const VARIANT &Formula, long FromReferenceStyle, const VARIANT &ToReferenceStyle, const VARIANT &ToAbsolute, const VARIANT &RelativeTo)
void SetEnableAnimations(BOOL bNewValue)
BOOL GetMoveAfterReturn()
void SetCommandUnderlines(long nNewValue)
void OnUndo(LPCTSTR Text, LPCTSTR Procedure)
void SetMoveAfterReturnDirection(long nNewValue)
BOOL GetEnableAnimations()
void SetUILanguage(long nNewValue)
LPDISPATCH GetRecentFiles()
VARIANT GetSaveAsFilename(const VARIANT &InitialFilename, const VARIANT &FileFilter, const VARIANT &FilterIndex, const VARIANT &Title, const VARIANT &ButtonText)
void SetDisplayRecentFiles(BOOL bNewValue)
void SetMoveAfterReturn(BOOL bNewValue)
BOOL GetCellDragAndDrop()
long GetMoveAfterReturnDirection()
double InchesToPoints(double Inches)
BOOL GetDisplayFullScreen()
void SetEnableSound(BOOL bNewValue)
void SetEnableEvents(BOOL bNewValue)
BOOL GetIgnoreRemoteRequests()
long GetDefaultSheetDirection()
void SetCursor(long nNewValue)
void SetCutCopyMode(long nNewValue)
LPDISPATCH GetODBCErrors()
void Help(const VARIANT &HelpFile, const VARIANT &HelpContextID)
BOOL CheckSpelling(LPCTSTR Word, const VARIANT &CustomDictionary, const VARIANT &IgnoreUppercase)
void SetWidth(double newValue)
void SetCellDragAndDrop(BOOL bNewValue)
BOOL RegisterXLL(LPCTSTR Filename)
BOOL GetDisplayStatusBar()
void SetDisplayAlerts(BOOL bNewValue)
CString GetActivePrinter()
LPDISPATCH GetActiveWindow()
double CentimetersToPoints(double Centimeters)
VARIANT _Evaluate(const VARIANT &Name)
void SetControlCharacters(long nNewValue)
void SetTransitionNavigKeys(BOOL bNewValue)
VARIANT GetPreviousSelections(const VARIANT &Index)
LPDISPATCH GetAssistant()
LPDISPATCH Union(LPDISPATCH Arg1, LPDISPATCH Arg2, const VARIANT &Arg3, const VARIANT &Arg4, const VARIANT &Arg5, const VARIANT &Arg6, const VARIANT &Arg7, const VARIANT &Arg8, const VARIANT &Arg9, const VARIANT &Arg10, const VARIANT &Arg11, const VARIANT &Arg12, const VARIANT &Arg13, const VARIANT &Arg14, const VARIANT &Arg15, const VARIANT &Arg16, const VARIANT &Arg17, const VARIANT &Arg18, const VARIANT &Arg19, const VARIANT &Arg20, const VARIANT &Arg21, const VARIANT &Arg22, const VARIANT &Arg23, const VARIANT &Arg24, const VARIANT &Arg25, const VARIANT &Arg26, const VARIANT &Arg27, const VARIANT &Arg28, const VARIANT &Arg29, const VARIANT &Arg30)
BOOL GetPivotTableSelection()
void SetEditDirectlyInCell(BOOL bNewValue)
void AddCustomList(const VARIANT &ListArray, const VARIANT &ByRow)
BOOL GetShowChartTipValues()
void SetDisplayExcel4Menus(BOOL bNewValue)
void OnTime(const VARIANT &EarliestTime, LPCTSTR Procedure, const VARIANT &LatestTime, const VARIANT &Schedule)
void SetFixedDecimal(BOOL bNewValue)
LPDISPATCH GetExcel4IntlMacroSheets()
void OnKey(LPCTSTR Key, const VARIANT &Procedure)
void Wait(const VARIANT &Time)
void SetStatusBar(const VARIANT &newValue)
CString GetNetworkTemplatesPath()
void ActivateMicrosoftApp(long Index)
long GetControlCharacters()
_Application(LPDISPATCH pDispatch)
void SetOnWindow(LPCTSTR lpszNewValue)
void DeleteChartAutoFormat(LPCTSTR Name)
VARIANT GetInternational(const VARIANT &Index)
BOOL GetAlertBeforeOverwriting()
BOOL GetDisplayClipboardWindow()
long GetFixedDecimalPlaces()
void SetAltStartupPath(LPCTSTR lpszNewValue)
CString GetTransitionMenuKey()
void SetEnableCancelKey(long nNewValue)
LPDISPATCH GetSelection()
void SetIteration(BOOL bNewValue)
void DDEPoke(long Channel, const VARIANT &Item, const VARIANT &Data)
void SetDisplayCommentIndicator(long nNewValue)
void SetStandardFontSize(double newValue)
BOOL GetDisplayFormulaBar()
BOOL GetCanRecordSounds()
double GetStandardFontSize()
void SetIgnoreRemoteRequests(BOOL bNewValue)
VARIANT Run(const VARIANT &Macro, const VARIANT &Arg1, const VARIANT &Arg2, const VARIANT &Arg3, const VARIANT &Arg4, const VARIANT &Arg5, const VARIANT &Arg6, const VARIANT &Arg7, const VARIANT &Arg8, const VARIANT &Arg9, const VARIANT &Arg10, const VARIANT &Arg11, const VARIANT &Arg12, const VARIANT &Arg13, const VARIANT &Arg14, const VARIANT &Arg15, const VARIANT &Arg16, const VARIANT &Arg17, const VARIANT &Arg18, const VARIANT &Arg19, const VARIANT &Arg20, const VARIANT &Arg21, const VARIANT &Arg22, const VARIANT &Arg23, const VARIANT &Arg24, const VARIANT &Arg25, const VARIANT &Arg26, const VARIANT &Arg27, const VARIANT &Arg28, const VARIANT &Arg29, const VARIANT &Arg30)
LPDISPATCH GetFileSearch()
void SetDisplayNoteIndicator(BOOL bNewValue)
void SetCursorMovement(long nNewValue)
void SetVisible(BOOL bNewValue)
void SetStandardFont(LPCTSTR lpszNewValue)
CString GetOperatingSystem()
void SetMaxIterations(long nNewValue)
void SetPromptForSummaryInfo(BOOL bNewValue)
VARIANT InputBox(LPCTSTR Prompt, const VARIANT &Title, const VARIANT &Default, const VARIANT &Left, const VARIANT &Top, const VARIANT &HelpFile, const VARIANT &HelpContextID, const VARIANT &Type)
long GetCommandUnderlines()
void OnRepeat(LPCTSTR Text, LPCTSTR Procedure)
void SetCopyObjectsWithCells(BOOL bNewValue)
LPDISPATCH GetActiveWorkbook()
void Goto(const VARIANT &Reference, const VARIANT &Scroll)
void Volatile(const VARIANT &Volatile)
CString GetOrganizationName()
void DeleteCustomList(long ListNum)
void SetHeight(double newValue)
VARIANT GetOpenFilename(const VARIANT &FileFilter, const VARIANT &FilterIndex, const VARIANT &Title, const VARIANT &ButtonText, const VARIANT &MultiSelect)
void SetInteractive(BOOL bNewValue)
BOOL GetMathCoprocessorAvailable()
VARIANT _Run2(const VARIANT &Macro, const VARIANT &Arg1, const VARIANT &Arg2, const VARIANT &Arg3, const VARIANT &Arg4, const VARIANT &Arg5, const VARIANT &Arg6, const VARIANT &Arg7, const VARIANT &Arg8, const VARIANT &Arg9, const VARIANT &Arg10, const VARIANT &Arg11, const VARIANT &Arg12, const VARIANT &Arg13, const VARIANT &Arg14, const VARIANT &Arg15, const VARIANT &Arg16, const VARIANT &Arg17, const VARIANT &Arg18, const VARIANT &Arg19, const VARIANT &Arg20, const VARIANT &Arg21, const VARIANT &Arg22, const VARIANT &Arg23, const VARIANT &Arg24, const VARIANT &Arg25, const VARIANT &Arg26, const VARIANT &Arg27, const VARIANT &Arg28, const VARIANT &Arg29, const VARIANT &Arg30)
LPDISPATCH GetThisWorkbook()
void SaveWorkspace(const VARIANT &Filename)
long GetDisplayCommentIndicator()
long GetDefaultSaveFormat()
void SetUserControl(BOOL bNewValue)
long GetTransitionMenuKeyAction()
void SetFixedDecimalPlaces(long nNewValue)
LPDISPATCH GetCommandBars()
long GetCustomListNum(const VARIANT &ListArray)
void SetDisplayFullScreen(BOOL bNewValue)
void SetPivotTableSelection(BOOL bNewValue)
void SetConstrainNumeric(BOOL bNewValue)
void AddChartAutoFormat(const VARIANT &Chart, LPCTSTR Name, const VARIANT &Description)
CString GetPathSeparator()
void SetODBCTimeout(long nNewValue)
void SetDefaultChart(const VARIANT &FormatName, const VARIANT &Gallery)
void SetDisplayClipboardWindow(BOOL bNewValue)
void SetActivePrinter(LPCTSTR lpszNewValue)
BOOL GetPromptForSummaryInfo()
CString GetStandardFont()
CString GetDefaultFilePath()
void SetUserName(LPCTSTR lpszNewValue)
void SetRollZoom(BOOL bNewValue)
void SetLeft(double newValue)
long GetSheetsInNewWorkbook()
LPDISPATCH Intersect(LPDISPATCH Arg1, LPDISPATCH Arg2, const VARIANT &Arg3, const VARIANT &Arg4, const VARIANT &Arg5, const VARIANT &Arg6, const VARIANT &Arg7, const VARIANT &Arg8, const VARIANT &Arg9, const VARIANT &Arg10, const VARIANT &Arg11, const VARIANT &Arg12, const VARIANT &Arg13, const VARIANT &Arg14, const VARIANT &Arg15, const VARIANT &Arg16, const VARIANT &Arg17, const VARIANT &Arg18, const VARIANT &Arg19, const VARIANT &Arg20, const VARIANT &Arg21, const VARIANT &Arg22, const VARIANT &Arg23, const VARIANT &Arg24, const VARIANT &Arg25, const VARIANT &Arg26, const VARIANT &Arg27, const VARIANT &Arg28, const VARIANT &Arg29, const VARIANT &Arg30)
void RecordMacro(const VARIANT &BasicCode, const VARIANT &XlmCode)
void SetCaption(LPCTSTR lpszNewValue)
LPDISPATCH GetWorksheets()
void SetDisplayScrollBars(BOOL bNewValue)
void SetEnableAutoComplete(BOOL bNewValue)
BOOL GetCalculateBeforeSave()
BOOL GetCopyObjectsWithCells()
VARIANT DDERequest(long Channel, LPCTSTR Item)
_Application(const _Application &dispatchSrc)
LPDISPATCH GetApplication()
void SetCalculation(long nNewValue)
BOOL GetDisplayRecentFiles()
VARIANT Evaluate(const VARIANT &Name)
void SetShowToolTips(BOOL bNewValue)
LPDISPATCH GetRange(const VARIANT &Cell1, const VARIANT &Cell2)
void DDEExecute(long Channel, LPCTSTR String)
BOOL GetDisplayScrollBars()
void DDETerminate(long Channel)
void SetCalculateBeforeSave(BOOL bNewValue)
CString GetAltStartupPath()
long GetEnableCancelKey()
void SetWindowState(long nNewValue)
void SetAlertBeforeOverwriting(BOOL bNewValue)
void SetReferenceStyle(long nNewValue)
BOOL GetAskToUpdateLinks()
VARIANT GetRegisteredFunctions(const VARIANT &Index1, const VARIANT &Index2)
void MailLogon(const VARIANT &Name, const VARIANT &Password, const VARIANT &DownloadNewMail)
LPDISPATCH GetActiveSheet()
void SetSheetsInNewWorkbook(long nNewValue)
BOOL GetDisplayExcel4Menus()
void SendKeys(const VARIANT &Keys, const VARIANT &Wait)
void SetTop(double newValue)
void SetListChangesOnNewSheet(BOOL bNewValue)
void SetUpdateRemoteReferences(BOOL bNewValue)
void RemoveUser(long Index)
LPDISPATCH GetRoutingSlip()
void ProtectSharing(const VARIANT &Filename, const VARIANT &Password, const VARIANT &WriteResPassword, const VARIANT &ReadOnlyRecommended, const VARIANT &CreateBackup, const VARIANT &SharingPassword)
BOOL GetPrecisionAsDisplayed()
void SetShowConflictHistory(BOOL bNewValue)
void SetConflictResolution(long nNewValue)
void ChangeFileAccess(long Mode, const VARIANT &WritePassword, const VARIANT &Notify)
BOOL GetTemplateRemoveExtData()
void MergeWorkbook(const VARIANT &Filename)
LPDISPATCH GetContainer()
void SetAutoUpdateSaveChanges(BOOL bNewValue)
void SetIsAddin(BOOL bNewValue)
void AcceptAllChanges(const VARIANT &When, const VARIANT &Who, const VARIANT &Where)
LPDISPATCH GetExcel4IntlMacroSheets()
void PrintPreview(const VARIANT &EnableChanges)
LPDISPATCH GetActiveChart()
void SetSaved(BOOL bNewValue)
void PrintOut(const VARIANT &From, const VARIANT &To, const VARIANT &Copies, const VARIANT &Preview, const VARIANT &ActivePrinter, const VARIANT &PrintToFile, const VARIANT &Collate)
void SaveAs(const VARIANT &Filename, const VARIANT &FileFormat, const VARIANT &Password, const VARIANT &WriteResPassword, const VARIANT &ReadOnlyRecommended, const VARIANT &CreateBackup, long AccessMode, const VARIANT &ConflictResolution, const VARIANT &AddToMru, const VARIANT &TextCodepage, const VARIANT &TextVisualLayout)
VARIANT LinkInfo(LPCTSTR Name, long LinkInfo, const VARIANT &Type, const VARIANT &EditionRef)
void SaveCopyAs(const VARIANT &Filename)
void Close(const VARIANT &SaveChanges, const VARIANT &Filename, const VARIANT &RouteWorkbook)
void UpdateLink(const VARIANT &Name, const VARIANT &Type)
BOOL GetAutoUpdateSaveChanges()
CString GetWriteReservedBy()
void SetChangeHistoryDuration(long nNewValue)
void HighlightChangesOptions(const VARIANT &When, const VARIANT &Who, const VARIANT &Where)
BOOL GetHighlightChangesOnScreen()
long GetConflictResolution()
void SetHighlightChangesOnScreen(BOOL bNewValue)
LPDISPATCH GetBuiltinDocumentProperties()
void RejectAllChanges(const VARIANT &When, const VARIANT &Who, const VARIANT &Where)
BOOL GetUpdateRemoteReferences()
LPDISPATCH GetApplication()
BOOL GetKeepChangeHistory()
BOOL GetAcceptLabelsInFormulas()
_Workbook(const _Workbook &dispatchSrc)
long GetAutoUpdateFrequency()
void SetDate1904(BOOL bNewValue)
LPDISPATCH GetCustomViews()
void SetHasRoutingSlip(BOOL bNewValue)
LPDISPATCH GetCommandBars()
void SendMailer(const VARIANT &FileFormat, long Priority)
void SendMail(const VARIANT &Recipients, const VARIANT &Subject, const VARIANT &ReturnReceipt)
void Post(const VARIANT &DestName)
void SetPrecisionAsDisplayed(BOOL bNewValue)
void SetKeepChangeHistory(BOOL bNewValue)
void SetAutoUpdateFrequency(long nNewValue)
void SetColors(const VARIANT &Index, const VARIANT &newValue)
BOOL GetShowConflictHistory()
void FollowHyperlink(LPCTSTR Address, const VARIANT &SubAddress, const VARIANT &NewWindow, const VARIANT &AddHistory, const VARIANT &ExtraInfo, const VARIANT &Method, const VARIANT &HeaderInfo)
void SetTemplateRemoveExtData(BOOL bNewValue)
BOOL GetProtectStructure()
void ChangeLink(LPCTSTR Name, LPCTSTR NewName, long Type)
void SetDisplayDrawingObjects(long nNewValue)
void SetPersonalViewPrintSettings(BOOL bNewValue)
void DeleteNumberFormat(LPCTSTR NumberFormat)
void PurgeChangeHistoryNow(long Days, const VARIANT &SharingPassword)
void UnprotectSharing(const VARIANT &SharingPassword)
BOOL GetReadOnlyRecommended()
void SetPersonalViewListSettings(BOOL bNewValue)
LPDISPATCH GetCustomDocumentProperties()
void OpenLinks(LPCTSTR Name, const VARIANT &ReadOnly, const VARIANT &Type)
void Set_CodeName(LPCTSTR lpszNewValue)
void SetAcceptLabelsInFormulas(BOOL bNewValue)
BOOL GetPersonalViewPrintSettings()
void Protect(const VARIANT &Password, const VARIANT &Structure, const VARIANT &Windows)
LPDISPATCH GetExcel4MacroSheets()
void SetSaveLinkValues(BOOL bNewValue)
VARIANT LinkSources(const VARIANT &Type)
BOOL GetMultiUserEditing()
void RunAutoMacros(long Which)
BOOL GetListChangesOnNewSheet()
LPDISPATCH GetWorksheets()
void Unprotect(const VARIANT &Password)
long GetChangeHistoryDuration()
long GetDisplayDrawingObjects()
LPDISPATCH GetActiveSheet()
LPDISPATCH GetVBProject()
BOOL GetPersonalViewListSettings()
_Workbook(LPDISPATCH pDispatch)
VARIANT GetColors(const VARIANT &Index)
void SetLinkOnData(LPCTSTR Name, const VARIANT &Procedure)
LPDISPATCH Scenarios(const VARIANT &Index)
void Copy(const VARIANT &Before, const VARIANT &After)
void PrintPreview(const VARIANT &EnableChanges)
void SetDisplayPageBreaks(BOOL bNewValue)
BOOL GetTransitionExpEval()
void Paste(const VARIANT &Destination, const VARIANT &Link)
LPDISPATCH GetRange(const VARIANT &Cell1, const VARIANT &Cell2)
LPDISPATCH PivotTables(const VARIANT &Index)
BOOL GetEnablePivotTable()
VARIANT Evaluate(const VARIANT &Name)
long GetEnableSelection()
LPDISPATCH GetApplication()
void Select(const VARIANT &Replace)
void ResetAllPageBreaks()
LPDISPATCH GetPageSetup()
void Unprotect(const VARIANT &Password)
BOOL GetProtectScenarios()
LPDISPATCH GetAutoFilter()
void SetBackgroundPicture(LPCTSTR Filename)
void PasteSpecial(const VARIANT &Format, const VARIANT &Link, const VARIANT &DisplayAsIcon, const VARIANT &IconFileName, const VARIANT &IconIndex, const VARIANT &IconLabel)
BOOL GetProtectContents()
BOOL GetEnableOutlining()
BOOL GetProtectDrawingObjects()
void SetTransitionFormEntry(BOOL bNewValue)
void SetEnablePivotTable(BOOL bNewValue)
LPDISPATCH GetHyperlinks()
void Move(const VARIANT &Before, const VARIANT &After)
LPDISPATCH OLEObjects(const VARIANT &Index)
LPDISPATCH GetVPageBreaks()
void SetTransitionExpEval(BOOL bNewValue)
void Protect(const VARIANT &Password, const VARIANT &DrawingObjects, const VARIANT &Contents, const VARIANT &Scenarios, const VARIANT &UserInterfaceOnly)
VARIANT _Evaluate(const VARIANT &Name)
LPDISPATCH ChartObjects(const VARIANT &Index)
_Worksheet(const _Worksheet &dispatchSrc)
void SetEnableCalculation(BOOL bNewValue)
BOOL GetTransitionFormEntry()
VARIANT GetConsolidationOptions()
LPDISPATCH GetCircularReference()
void SetAutoFilterMode(BOOL bNewValue)
void SaveAs(LPCTSTR Filename, const VARIANT &FileFormat, const VARIANT &Password, const VARIANT &WriteResPassword, const VARIANT &ReadOnlyRecommended, const VARIANT &CreateBackup, const VARIANT &AddToMru, const VARIANT &TextCodepage, const VARIANT &TextVisualLayout)
_Worksheet(LPDISPATCH pDispatch)
void SetName(LPCTSTR lpszNewValue)
void Set_CodeName(LPCTSTR lpszNewValue)
BOOL GetDisplayPageBreaks()
double GetStandardWidth()
void PrintOut(const VARIANT &From, const VARIANT &To, const VARIANT &Copies, const VARIANT &Preview, const VARIANT &ActivePrinter, const VARIANT &PrintToFile, const VARIANT &Collate)
void SetEnableSelection(long nNewValue)
void SetScrollArea(LPCTSTR lpszNewValue)
LPDISPATCH PivotTableWizard(const VARIANT &SourceType, const VARIANT &SourceData, const VARIANT &TableDestination, const VARIANT &TableName, const VARIANT &RowGrand, const VARIANT &ColumnGrand, const VARIANT &SaveData, const VARIANT &HasAutoFormat, const VARIANT &AutoPage, const VARIANT &Reserved, const VARIANT &BackgroundQuery, const VARIANT &OptimizeCache, const VARIANT &PageFieldOrder, const VARIANT &PageFieldWrapCount, const VARIANT &ReadData, const VARIANT &Connection)
void SetStandardWidth(double newValue)
void SetVisible(long nNewValue)
double GetStandardHeight()
BOOL GetEnableAutoFilter()
LPDISPATCH GetHPageBreaks()
BOOL GetEnableCalculation()
LPDISPATCH GetUsedRange()
void SetEnableOutlining(BOOL bNewValue)
VARIANT GetConsolidationSources()
void SetEnableAutoFilter(BOOL bNewValue)
long GetConsolidationFunction()
LPDISPATCH GetQueryTables()
void CheckSpelling(const VARIANT &CustomDictionary, const VARIANT &IgnoreUppercase, const VARIANT &AlwaysSuggest, const VARIANT &IgnoreInitialAlefHamza, const VARIANT &IgnoreFinalYaa, const VARIANT &SpellScript)
void SetColor(const VARIANT &newValue)
Border(LPDISPATCH pDispatch)
LPDISPATCH GetApplication()
void SetLineStyle(const VARIANT &newValue)
void SetWeight(const VARIANT &newValue)
void SetColorIndex(const VARIANT &newValue)
Border(const Border &dispatchSrc)
LPDISPATCH GetApplication()
LPDISPATCH Get_Default(long Index)
void SetColorIndex(const VARIANT &newValue)
void SetWeight(const VARIANT &newValue)
void SetLineStyle(const VARIANT &newValue)
void SetValue(const VARIANT &newValue)
LPDISPATCH GetItem(long Index)
Borders(const Borders &dispatchSrc)
void SetColor(const VARIANT &newValue)
Borders(LPDISPATCH pDispatch)
VARIANT GetPatternColor()
VARIANT GetInvertIfNegative()
Interior(LPDISPATCH pDispatch)
void SetColorIndex(const VARIANT &newValue)
Interior(const Interior &dispatchSrc)
void SetPatternColorIndex(const VARIANT &newValue)
void SetPattern(const VARIANT &newValue)
void SetPatternColor(const VARIANT &newValue)
VARIANT GetPatternColorIndex()
void SetColor(const VARIANT &newValue)
void SetInvertIfNegative(const VARIANT &newValue)
LPDISPATCH GetApplication()
void SetFormulaLocal(const VARIANT &newValue)
void AutoFilter(const VARIANT &Field, const VARIANT &Criteria1, long Operator, const VARIANT &Criteria2, const VARIANT &VisibleDropDown)
void SortSpecial(long SortMethod, const VARIANT &Key1, long Order1, const VARIANT &Type, const VARIANT &Key2, long Order2, const VARIANT &Key3, long Order3, long Header, const VARIANT &OrderCustom, const VARIANT &MatchCase, long Orientation)
void Subtotal(long GroupBy, long Function, const VARIANT &TotalList, const VARIANT &Replace, const VARIANT &PageBreaks, long SummaryBelowData)
void NavigateArrow(const VARIANT &TowardPrecedent, const VARIANT &ArrowNumber, const VARIANT &LinkNumber)
VARIANT GetFormulaArray()
LPDISPATCH GetHyperlinks()
long GetLocationInTable()
void SetShrinkToFit(const VARIANT &newValue)
void CreateNames(const VARIANT &Top, const VARIANT &Left, const VARIANT &Bottom, const VARIANT &Right)
LPDISPATCH GetPivotTable()
void ApplyOutlineStyles()
VARIANT GetFormulaHidden()
void SetRowHeight(const VARIANT &newValue)
LPDISPATCH GetCurrentArray()
void TextToColumns(const VARIANT &Destination, long DataType, long TextQualifier, const VARIANT &ConsecutiveDelimiter, const VARIANT &Tab, const VARIANT &Semicolon, const VARIANT &Comma, const VARIANT &Space, const VARIANT &Other, const VARIANT &OtherChar, const VARIANT &FieldInfo)
long CopyFromRecordset(LPUNKNOWN Data, const VARIANT &MaxRows, const VARIANT &MaxColumns)
VARIANT EditionOptions(long Type, long Option, const VARIANT &Name, const VARIANT &Reference, long Appearance, long ChartSize, const VARIANT &Format)
void SetFormulaR1C1Local(const VARIANT &newValue)
void SetShowDetail(const VARIANT &newValue)
void DataSeries(const VARIANT &Rowcol, long Type, long Date, const VARIANT &Step, const VARIANT &Stop, const VARIANT &Trend)
Range(LPDISPATCH pDispatch)
BOOL GoalSeek(const VARIANT &Goal, LPDISPATCH ChangingCell)
void SetLocked(const VARIANT &newValue)
LPDISPATCH AddComment(const VARIANT &Text)
void SetItem(const VARIANT &RowIndex, const VARIANT &ColumnIndex, const VARIANT &newValue)
VARIANT GetVerticalAlignment()
void CreatePublisher(const VARIANT &Edition, long Appearance, const VARIANT &ContainsPICT, const VARIANT &ContainsBIFF, const VARIANT &ContainsRTF, const VARIANT &ContainsVALU)
VARIANT GetFormulaLocal()
LPDISPATCH GetEnd(long Direction)
LPDISPATCH GetApplication()
void 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)
void BorderAround(const VARIANT &LineStyle, long Weight, long ColorIndex, const VARIANT &Color)
void SetHidden(const VARIANT &newValue)
void InsertIndent(long InsertAmount)
VARIANT GetHorizontalAlignment()
void SubscribeTo(LPCTSTR Edition, long Format)
VARIANT GetUseStandardHeight()
void SetFormulaLabel(long nNewValue)
void SetStyle(const VARIANT &newValue)
LPDISPATCH GetCurrentRegion()
void SetFormulaArray(const VARIANT &newValue)
void SetNumberFormat(const VARIANT &newValue)
void SetFormula(const VARIANT &newValue)
void PrintOut(const VARIANT &From, const VARIANT &To, const VARIANT &Copies, const VARIANT &Preview, const VARIANT &ActivePrinter, const VARIANT &PrintToFile, const VARIANT &Collate)
void Insert(const VARIANT &Shift)
void SetNumberFormatLocal(const VARIANT &newValue)
LPDISPATCH GetCharacters(const VARIANT &Start, const VARIANT &Length)
LPDISPATCH FindPrevious(const VARIANT &After)
LPDISPATCH GetDirectDependents()
LPDISPATCH GetSoundNote()
CString NoteText(const VARIANT &Text, const VARIANT &Start, const VARIANT &Length)
void SetOutlineLevel(const VARIANT &newValue)
LPDISPATCH ColumnDifferences(const VARIANT &Comparison)
LPDISPATCH SpecialCells(long Type, const VARIANT &Value)
LPDISPATCH GetDependents()
VARIANT GetFormulaR1C1Local()
void PrintPreview(const VARIANT &EnableChanges)
void AutoFill(LPDISPATCH Destination, long Type)
VARIANT GetNumberFormat()
void ShowDependents(const VARIANT &Remove)
void SetReadingOrder(long nNewValue)
VARIANT Run(const VARIANT &Arg1, const VARIANT &Arg2, const VARIANT &Arg3, const VARIANT &Arg4, const VARIANT &Arg5, const VARIANT &Arg6, const VARIANT &Arg7, const VARIANT &Arg8, const VARIANT &Arg9, const VARIANT &Arg10, const VARIANT &Arg11, const VARIANT &Arg12, const VARIANT &Arg13, const VARIANT &Arg14, const VARIANT &Arg15, const VARIANT &Arg16, const VARIANT &Arg17, const VARIANT &Arg18, const VARIANT &Arg19, const VARIANT &Arg20, const VARIANT &Arg21, const VARIANT &Arg22, const VARIANT &Arg23, const VARIANT &Arg24, const VARIANT &Arg25, const VARIANT &Arg26, const VARIANT &Arg27, const VARIANT &Arg28, const VARIANT &Arg29, const VARIANT &Arg30)
void CopyPicture(long Appearance, long Format)
BOOL Replace(const VARIANT &What, const VARIANT &Replacement, const VARIANT &LookAt, const VARIANT &SearchOrder, const VARIANT &MatchCase, const VARIANT &MatchByte, const VARIANT &MatchControlCharacters, const VARIANT &MatchDiacritics, const VARIANT &MatchKashida, const VARIANT &MatchAlefHamza)
LPDISPATCH GetOffset(const VARIANT &RowOffset, const VARIANT &ColumnOffset)
void AutoFormat(long Format, const VARIANT &Number, const VARIANT &Font, const VARIANT &Alignment, const VARIANT &Border, const VARIANT &Pattern, const VARIANT &Width)
LPDISPATCH RowDifferences(const VARIANT &Comparison)
void Merge(const VARIANT &Across)
CString GetAddressLocal(const VARIANT &RowAbsolute, const VARIANT &ColumnAbsolute, long ReferenceStyle, const VARIANT &External, const VARIANT &RelativeTo)
void Parse(const VARIANT &ParseLine, const VARIANT &Destination)
LPDISPATCH GetValidation()
void Delete(const VARIANT &Shift)
LPDISPATCH GetFormatConditions()
void SetAddIndent(const VARIANT &newValue)
void SetUseStandardHeight(const VARIANT &newValue)
void SetFormulaHidden(const VARIANT &newValue)
void Cut(const VARIANT &Destination)
LPDISPATCH GetEntireRow()
void PasteSpecial(long Paste, long Operation, const VARIANT &SkipBlanks, const VARIANT &Transpose)
CString GetAddress(const VARIANT &RowAbsolute, const VARIANT &ColumnAbsolute, long ReferenceStyle, const VARIANT &External, const VARIANT &RelativeTo)
void CheckSpelling(const VARIANT &CustomDictionary, const VARIANT &IgnoreUppercase, const VARIANT &AlwaysSuggest, const VARIANT &IgnoreInitialAlefHamza, const VARIANT &IgnoreFinalYaa, const VARIANT &SpellScript)
void SetFormulaR1C1(const VARIANT &newValue)
LPDISPATCH FindNext(const VARIANT &After)
VARIANT GetOutlineLevel()
void SetValue2(const VARIANT &newValue)
LPDISPATCH GetPrecedents()
VARIANT GetUseStandardWidth()
LPDISPATCH GetRange(const VARIANT &Cell1, const VARIANT &Cell2)
void Table(const VARIANT &RowInput, const VARIANT &ColumnInput)
void Consolidate(const VARIANT &Sources, const VARIANT &Function, const VARIANT &TopRow, const VARIANT &LeftColumn, const VARIANT &CreateLinks)
void SetColumnWidth(const VARIANT &newValue)
VARIANT Get_Default(const VARIANT &RowIndex, const VARIANT &ColumnIndex)
void Copy(const VARIANT &Destination)
void SetUseStandardWidth(const VARIANT &newValue)
void SetHorizontalAlignment(const VARIANT &newValue)
LPDISPATCH GetEntireColumn()
void Set_Default(const VARIANT &RowIndex, const VARIANT &ColumnIndex, const VARIANT &newValue)
void ApplyNames(const VARIANT &Names, const VARIANT &IgnoreRelativeAbsolute, const VARIANT &UseRowColumnNames, const VARIANT &OmitColumn, const VARIANT &OmitRow, long Order, const VARIANT &AppendLast)
VARIANT GetPrefixCharacter()
void SetVerticalAlignment(const VARIANT &newValue)
Range(const Range &dispatchSrc)
LPDISPATCH GetQueryTable()
CString AutoComplete(LPCTSTR String)
LPDISPATCH GetWorksheet()
void AdvancedFilter(long Action, const VARIANT &CriteriaRange, const VARIANT &CopyToRange, const VARIANT &Unique)
VARIANT GetItem(const VARIANT &RowIndex, const VARIANT &ColumnIndex)
LPDISPATCH GetPivotField()
void SetValue(const VARIANT &newValue)
LPDISPATCH GetMergeArea()
LPDISPATCH GetPivotItem()
void ShowPrecedents(const VARIANT &Remove)
LPDISPATCH Find(const VARIANT &What, const VARIANT &After, const VARIANT &LookIn, const VARIANT &LookAt, const VARIANT &SearchOrder, long SearchDirection, const VARIANT &MatchCase, const VARIANT &MatchByte, const VARIANT &MatchControlCharacters, const VARIANT &MatchDiacritics, const VARIANT &MatchKashida, const VARIANT &MatchAlefHamza)
LPDISPATCH GetDirectPrecedents()
LPDISPATCH GetResize(const VARIANT &RowSize, const VARIANT &ColumnSize)
void SetIndentLevel(const VARIANT &newValue)
void SetPageBreak(long nNewValue)
void SetName(const VARIANT &newValue)
void SetWrapText(const VARIANT &newValue)
VARIANT GetNumberFormatLocal()
void SetOrientation(const VARIANT &newValue)
void SetMergeCells(const VARIANT &newValue)
Workbooks(const Workbooks &dispatchSrc)
Workbooks(LPDISPATCH pDispatch)
LPDISPATCH Add(const VARIANT &Template)
LPDISPATCH Get_Default(const VARIANT &Index)
LPDISPATCH GetApplication()
LPDISPATCH GetItem(const VARIANT &Index)
void OpenText(LPCTSTR Filename, const VARIANT &Origin, const VARIANT &StartRow, const VARIANT &DataType, long TextQualifier, const VARIANT &ConsecutiveDelimiter, const VARIANT &Tab, const VARIANT &Semicolon, const VARIANT &Comma, const VARIANT &Space, const VARIANT &Other, const VARIANT &OtherChar, const VARIANT &FieldInfo, const VARIANT &TextVisualLayout)
LPDISPATCH Open(LPCTSTR Filename, const VARIANT &UpdateLinks, const VARIANT &ReadOnly, const VARIANT &Format, const VARIANT &Password, const VARIANT &WriteResPassword, const VARIANT &IgnoreReadOnlyRecommended, const VARIANT &Origin, const VARIANT &Delimiter, const VARIANT &Editable, const VARIANT &Notify, const VARIANT &Converter, const VARIANT &AddToMru)