Object Model Changes Since Microsoft Office 97

Article
06/14/2014

Excel Developer Reference

The following is a summary of the changes in the Microsoft Office Excel 2007 object model as compared to Microsoft Office 97.

Application

Properties	Status
CommandBars	Changed READ-ONLY CommandBars [_COMMANDBARS] READ-ONLY CommandBars [COMMANDBARS]
ControlCharacters	Changed READ-WRITE ControlCharacters [INT32] READ-WRITE ControlCharacters [BOOL]
FileFind	Hidden
FileSearch	Hidden
MemoryFree	Hidden
MemoryTotal	Hidden
MemoryUsed	Hidden
UILanguage	Hidden
VBE	Changed READ-ONLY VBE [unknown type] READ-ONLY VBE [VBE]

Methods	Status
AddChartAutoFormat	Hidden
DeleteChartAutoFormat	Hidden
FindFile	Changed VOID FindFile () BOOL FindFile ()
SetDefaultChart	Hidden
Wait	Changed VOID Wait (VARIANT Time) BOOL Wait (VARIANT Time)

AutoCorrect

Methods	Status
AddReplacement	Changed VOID AddReplacement (STRING What, STRING Replacement) VARIANT AddReplacement (STRING What, STRING Replacement)
DeleteReplacement	Changed VOID DeleteReplacement (STRING What) VARIANT DeleteReplacement (STRING What)
ReplacementList	Removed

Axis

Methods	Status
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select () VARIANT Select ()

AxisTitle

Properties	Status
AutoScaleFont	Hidden
Border	Hidden
Fill	Hidden
Font	Hidden
Interior	Hidden

Methods	Status
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select () VARIANT Select ()

CalculatedFields

Methods	Status
Add	Changed PIVOTFIELD Add (STRING Name, STRING Formula) PIVOTFIELD Add (STRING Name, STRING Formula, OPTIONAL VARIANT UseStandardFormula)

CalculatedItems

Methods	Status
Add	Changed PIVOTITEM Add (STRING Name, STRING Formula) PIVOTITEM Add (STRING Name, STRING Formula, OPTIONAL VARIANT UseStandardFormula)

Characters

Methods	Status
Delete	Changed VOID Delete () VARIANT Delete ()
Insert	Changed VOID Insert (STRING String) VARIANT Insert (STRING String)

Chart

Properties	Status
Area3DGroup	Hidden
Bar3DGroup	Hidden
Column3DGroup	Hidden
Corners	Hidden
Line3DGroup	Hidden
Pie3DGroup	Hidden
ProtectGoalSeek	Hidden
ShowWindow	Hidden
SizeWithWindow	Hidden
SurfaceGroup	Hidden
WallsAndGridlines2D	Hidden

Methods	Status
ApplyCustomType	Hidden
ApplyDataLabels	Changed VOID ApplyDataLabels (OPTIONAL XLDATALABELSTYPE Type = 2, OPTIONAL VARIANT LegendKey, OPTIONAL VARIANT AutoText, OPTIONAL VARIANT HasLeaderLines) VOID ApplyDataLabels (OPTIONAL XLDATALABELSTYPE Type = 2, OPTIONAL VARIANT LegendKey, OPTIONAL VARIANT AutoText, OPTIONAL VARIANT HasLeaderLines, OPTIONAL VARIANT ShowSeriesName, OPTIONAL VARIANT ShowCategoryName, OPTIONAL VARIANT ShowValue, OPTIONAL VARIANT ShowPercentage, OPTIONAL VARIANT ShowBubbleSize, OPTIONAL VARIANT Separator)
AreaGroups	Hidden
BarGroups	Hidden
CheckSpelling	Changed VOID CheckSpelling (OPTIONAL VARIANT CustomDictionary, OPTIONAL VARIANT IgnoreUppercase, OPTIONAL VARIANT AlwaysSuggest, OPTIONAL VARIANT IgnoreInitialAlefHamza, OPTIONAL VARIANT IgnoreFinalYaa, OPTIONAL VARIANT SpellScript) VOID CheckSpelling (OPTIONAL VARIANT CustomDictionary, OPTIONAL VARIANT IgnoreUppercase, OPTIONAL VARIANT AlwaysSuggest, OPTIONAL VARIANT SpellLang)
ColumnGroups	Hidden
CreatePublisher	Hidden
Deselect	Hidden
DoughnutGroups	Hidden
LineGroups	Hidden
PieGroups	Hidden
PrintOut	Changed VOID PrintOut (OPTIONAL VARIANT From, OPTIONAL VARIANT To, OPTIONAL VARIANT Copies, OPTIONAL VARIANT Preview, OPTIONAL VARIANT ActivePrinter, OPTIONAL VARIANT PrintToFile, OPTIONAL VARIANT Collate) VOID PrintOut (OPTIONAL VARIANT From, OPTIONAL VARIANT To, OPTIONAL VARIANT Copies, OPTIONAL VARIANT Preview, OPTIONAL VARIANT ActivePrinter, OPTIONAL VARIANT PrintToFile, OPTIONAL VARIANT Collate, OPTIONAL VARIANT PrToFileName)
RadarGroups	Hidden
SaveAs	Changed VOID SaveAs (STRING Filename, OPTIONAL VARIANT FileFormat, OPTIONAL VARIANT Password, OPTIONAL VARIANT WriteResPassword, OPTIONAL VARIANT ReadOnlyRecommended, OPTIONAL VARIANT CreateBackup, OPTIONAL VARIANT AddToMru, OPTIONAL VARIANT TextCodepage, OPTIONAL VARIANT TextVisualLayout) VOID SaveAs (STRING Filename, OPTIONAL VARIANT FileFormat, OPTIONAL VARIANT Password, OPTIONAL VARIANT WriteResPassword, OPTIONAL VARIANT ReadOnlyRecommended, OPTIONAL VARIANT CreateBackup, OPTIONAL VARIANT AddToMru, OPTIONAL VARIANT TextCodepage, OPTIONAL VARIANT TextVisualLayout, OPTIONAL VARIANT Local)
XYGroups	Hidden

Events	Status
BeforeDoubleClick	Changed BeforeDoubleClick (XLCHARTITEM ElementID, INT32 Arg1, INT32 Arg2, BOOL Cancel) BeforeDoubleClick (INT32 ElementID, INT32 Arg1, INT32 Arg2, BOOL Cancel)
DragOver	Hidden
DragPlot	Hidden
MouseDown	Changed MouseDown (XLMOUSEBUTTON Button, INT32 Shift, INT32 X, INT32 Y) MouseDown (INT32 Button, INT32 Shift, INT32 x, INT32 y)
MouseMove	Changed MouseMove (XLMOUSEBUTTON Button, INT32 Shift, INT32 X, INT32 Y) MouseMove (INT32 Button, INT32 Shift, INT32 x, INT32 y)
MouseUp	Changed MouseUp (XLMOUSEBUTTON Button, INT32 Shift, INT32 X, INT32 Y) MouseUp (INT32 Button, INT32 Shift, INT32 x, INT32 y)
Select	Changed Select (XLCHARTITEM ElementID, INT32 Arg1, INT32 Arg2) Select (INT32 ElementID, INT32 Arg1, INT32 Arg2)

ChartArea

Properties	Status
AutoScaleFont	Hidden
Border	Hidden
Fill	Hidden
Font	Hidden
Interior	Hidden

Methods	Status
Clear	Changed VOID Clear () VARIANT Clear ()
ClearContents	Changed VOID ClearContents () VARIANT ClearContents ()
ClearFormats	Changed VOID ClearFormats () VARIANT ClearFormats ()
Copy	Changed VOID Copy () VARIANT Copy ()
Select	Changed VOID Select () VARIANT Select ()

ChartColorFormat

Hidden

ChartFillFormat

Hidden

ChartObject

Properties	Status
Border	Hidden
Enabled	Hidden
Interior	Hidden

Methods	Status
Activate	Changed VOID Activate () VARIANT Activate ()
BringToFront	Changed VOID BringToFront () VARIANT BringToFront ()
Copy	Changed VOID Copy () VARIANT Copy ()
CopyPicture	Changed VOID CopyPicture (OPTIONAL XLPICTUREAPPEARANCE Appearance = 2, OPTIONAL XLCOPYPICTUREFORMAT Format = -4147) VARIANT CopyPicture (OPTIONAL XLPICTUREAPPEARANCE Appearance = 2, OPTIONAL XLCOPYPICTUREFORMAT Format = -4147)
Cut	Changed VOID Cut () VARIANT Cut ()
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select (OPTIONAL VARIANT Replace) VARIANT Select (OPTIONAL VARIANT Replace)
SendToBack	Changed VOID SendToBack () VARIANT SendToBack ()

ChartObjects

Properties	Status
Border	Hidden
Enabled	Hidden
Interior	Hidden
RoundedCorners	Hidden
Shadow	Hidden

Methods	Status
BringToFront	Hidden
Copy	Changed VOID Copy () VARIANT Copy ()
CopyPicture	Changed VOID CopyPicture (OPTIONAL XLPICTUREAPPEARANCE Appearance = 2, OPTIONAL XLCOPYPICTUREFORMAT Format = -4147) VARIANT CopyPicture (OPTIONAL XLPICTUREAPPEARANCE Appearance = 2, OPTIONAL XLCOPYPICTUREFORMAT Format = -4147)
Cut	Changed VOID Cut () VARIANT Cut ()
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select (OPTIONAL VARIANT Replace) VARIANT Select (OPTIONAL VARIANT Replace)
SendToBack	Hidden

Charts

Methods	Status
PrintOut	Changed VOID PrintOut (OPTIONAL VARIANT From, OPTIONAL VARIANT To, OPTIONAL VARIANT Copies, OPTIONAL VARIANT Preview, OPTIONAL VARIANT ActivePrinter, OPTIONAL VARIANT PrintToFile, OPTIONAL VARIANT Collate) VOID PrintOut (OPTIONAL VARIANT From, OPTIONAL VARIANT To, OPTIONAL VARIANT Copies, OPTIONAL VARIANT Preview, OPTIONAL VARIANT ActivePrinter, OPTIONAL VARIANT PrintToFile, OPTIONAL VARIANT Collate, OPTIONAL VARIANT PrToFileName)

PrintOut

Changed

VOID PrintOut (OPTIONAL VARIANT From, OPTIONAL VARIANT To, OPTIONAL VARIANT Copies, OPTIONAL VARIANT Preview, OPTIONAL VARIANT ActivePrinter, OPTIONAL VARIANT PrintToFile, OPTIONAL VARIANT Collate)

VOID PrintOut (OPTIONAL VARIANT From, OPTIONAL VARIANT To, OPTIONAL VARIANT Copies, OPTIONAL VARIANT Preview, OPTIONAL VARIANT ActivePrinter, OPTIONAL VARIANT PrintToFile, OPTIONAL VARIANT Collate, OPTIONAL VARIANT PrToFileName)

ChartTitle

Properties	Status
AutoScaleFont	Hidden
Border	Hidden
Fill	Hidden
Font	Hidden
Interior	Hidden

Methods	Status
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select () VARIANT Select ()

Corners

Hidden

DataLabel

Properties	Status
AutoScaleFont	Hidden
Border	Hidden
Fill	Hidden
Font	Hidden
Interior	Hidden
Type	Hidden

Methods	Status
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select () VARIANT Select ()

DataLabels

Properties	Status
AutoScaleFont	Hidden
Border	Hidden
Fill	Hidden
Font	Hidden
Interior	Hidden
Type	Hidden

Methods	Status
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select () VARIANT Select ()

DataTable

Properties	Status
AutoScaleFont	Hidden

DownBars

Properties	Status
Border	Hidden
Fill	Hidden
Interior	Hidden

Methods	Status
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select () VARIANT Select ()

DropLines

Methods	Status
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select () VARIANT Select ()

ErrorBars

Methods	Status
ClearFormats	Changed VOID ClearFormats () VARIANT ClearFormats ()
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select () VARIANT Select ()

Filter

Properties	Status
Operator	Changed READ-ONLY Operator [XLAUTOFILTEROPERATOR] READ-WRITE Operator [XLAUTOFILTEROPERATOR]

Floor

Properties	Status
Border	Hidden
Fill	Hidden
Interior	Hidden

Methods	Status
ClearFormats	Changed VOID ClearFormats () VARIANT ClearFormats ()
Select	Changed VOID Select () VARIANT Select ()

Font

Properties	Status
OutlineFont	Hidden
Shadow	Hidden

FormatCondition

Methods	Status
Modify	Changed VOID Modify (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2) VOID Modify (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2, OPTIONAL VARIANT String, OPTIONAL VARIANT Operator2)

FormatConditions

Methods	Status
Add	Changed FORMATCONDITION Add (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2) OBJECT Add (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2, OPTIONAL VARIANT String, OPTIONAL VARIANT TextOperator, OPTIONAL VARIANT DateOperator, OPTIONAL VARIANT ScopeType)
Item	Changed FORMATCONDITION Item (VARIANT Index) OBJECT Item (VARIANT Index)

Gridlines

Methods	Status
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select () VARIANT Select ()

HiLoLines

Methods	Status
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select () VARIANT Select ()

Hyperlinks

Methods	Status
Add	Changed OBJECT Add (OBJECT Anchor, STRING Address, OPTIONAL VARIANT SubAddress) OBJECT Add (OBJECT Anchor, STRING Address, OPTIONAL VARIANT SubAddress, OPTIONAL VARIANT ScreenTip, OPTIONAL VARIANT TextToDisplay)

Legend

Properties	Status
AutoScaleFont	Hidden
Border	Hidden
Fill	Hidden
Font	Hidden
Interior	Hidden

Methods	Status
Clear	Changed VOID Clear () VARIANT Clear ()
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select () VARIANT Select ()

LegendEntry

Properties	Status
AutoScaleFont	Hidden

Methods	Status
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select () VARIANT Select ()

LegendKey

Properties	Status
Border	Hidden
Fill	Hidden
Interior	Hidden
PictureUnit	Hidden

Methods	Status
ClearFormats	Changed VOID ClearFormats () VARIANT ClearFormats ()
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Hidden

OLEObject

Methods	Status
Activate	Changed VOID Activate () VARIANT Activate ()
BringToFront	Changed VOID BringToFront () VARIANT BringToFront ()
Copy	Changed VOID Copy () VARIANT Copy ()
CopyPicture	Changed VOID CopyPicture (OPTIONAL XLPICTUREAPPEARANCE Appearance = 2, OPTIONAL XLCOPYPICTUREFORMAT Format = -4147) VARIANT CopyPicture (OPTIONAL XLPICTUREAPPEARANCE Appearance = 2, OPTIONAL XLCOPYPICTUREFORMAT Format = -4147)
Cut	Changed VOID Cut () VARIANT Cut ()
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select (OPTIONAL VARIANT Replace) VARIANT Select (OPTIONAL VARIANT Replace)
SendToBack	Changed VOID SendToBack () VARIANT SendToBack ()
Update	Changed VOID Update () VARIANT Update ()
Verb	Changed VOID Verb (OPTIONAL XLOLEVERB Verb = 1) VARIANT Verb (OPTIONAL XLOLEVERB Verb = 1)

OLEObjects

Methods	Status
BringToFront	Changed VOID BringToFront () VARIANT BringToFront ()
Copy	Changed VOID Copy () VARIANT Copy ()
CopyPicture	Changed VOID CopyPicture (OPTIONAL XLPICTUREAPPEARANCE Appearance = 2, OPTIONAL XLCOPYPICTUREFORMAT Format = -4147) VARIANT CopyPicture (OPTIONAL XLPICTUREAPPEARANCE Appearance = 2, OPTIONAL XLCOPYPICTUREFORMAT Format = -4147)
Cut	Changed VOID Cut () VARIANT Cut ()
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select (OPTIONAL VARIANT Replace) VARIANT Select (OPTIONAL VARIANT Replace)
SendToBack	Changed VOID SendToBack () VARIANT SendToBack ()

Outline

Methods	Status
ShowLevels	Changed VOID ShowLevels (OPTIONAL VARIANT RowLevels, OPTIONAL VARIANT ColumnLevels) VARIANT ShowLevels (OPTIONAL VARIANT RowLevels, OPTIONAL VARIANT ColumnLevels)

PageSetup

Properties	Status
ChartSize	Hidden

Methods	Status
PrintQuality	Removed

Pane

Methods	Status
Activate	Changed VOID Activate () BOOL Activate ()
LargeScroll	Changed VOID LargeScroll (OPTIONAL VARIANT Down, OPTIONAL VARIANT Up, OPTIONAL VARIANT ToRight, OPTIONAL VARIANT ToLeft) VARIANT LargeScroll (OPTIONAL VARIANT Down, OPTIONAL VARIANT Up, OPTIONAL VARIANT ToRight, OPTIONAL VARIANT ToLeft)
SmallScroll	Changed VOID SmallScroll (OPTIONAL VARIANT Down, OPTIONAL VARIANT Up, OPTIONAL VARIANT ToRight, OPTIONAL VARIANT ToLeft) VARIANT SmallScroll (OPTIONAL VARIANT Down, OPTIONAL VARIANT Up, OPTIONAL VARIANT ToRight, OPTIONAL VARIANT ToLeft)

PivotCache

Properties	Status
Sql	Hidden

PivotField

Properties	Status
CurrentPage	Changed READ-WRITE CurrentPage [STRING] READ-WRITE CurrentPage [VARIANT]
Parent	Changed READ-ONLY Parent [PIVOTTABLE] READ-ONLY Parent [OBJECT]

Methods	Status
AutoSort	Changed VOID AutoSort (INT32 Order, STRING Field) VOID AutoSort (INT32 Order, STRING Field, OPTIONAL VARIANT PivotLine, OPTIONAL VARIANT CustomSubtotal)
Subtotals	Removed

PivotFormulas

Methods	Status
Add	Changed PIVOTFORMULA Add (STRING Formula) PIVOTFORMULA Add (STRING Formula, OPTIONAL VARIANT UseStandardFormula)

PivotTable

Properties	Status
HasAutoFormat	Hidden
TableStyle	Hidden

Methods	Status
AddFields	Changed VOID AddFields (OPTIONAL VARIANT RowFields, OPTIONAL VARIANT ColumnFields, OPTIONAL VARIANT PageFields, OPTIONAL VARIANT AddToTable) VARIANT AddFields (OPTIONAL VARIANT RowFields, OPTIONAL VARIANT ColumnFields, OPTIONAL VARIANT PageFields, OPTIONAL VARIANT AddToTable)
PivotFormulas	Removed
PivotSelect	Changed VOID PivotSelect (STRING Name, XLPTSELECTIONMODE Mode) VOID PivotSelect (STRING Name, OPTIONAL XLPTSELECTIONMODE Mode = 0, OPTIONAL VARIANT UseStandardName)
ShowPages	Changed VOID ShowPages (OPTIONAL VARIANT PageField) VARIANT ShowPages (OPTIONAL VARIANT PageField)

PlotArea

Properties	Status
Border	Hidden
Fill	Hidden
InsideHeight	Changed READ-ONLY InsideHeight [DOUBLE] READ-WRITE InsideHeight [DOUBLE]
InsideLeft	Changed READ-ONLY InsideLeft [DOUBLE] READ-WRITE InsideLeft [DOUBLE]
InsideTop	Changed READ-ONLY InsideTop [DOUBLE] READ-WRITE InsideTop [DOUBLE]
InsideWidth	Changed READ-ONLY InsideWidth [DOUBLE] READ-WRITE InsideWidth [DOUBLE]
Interior	Hidden

Methods	Status
ClearFormats	Changed VOID ClearFormats () VARIANT ClearFormats ()
Select	Changed VOID Select () VARIANT Select ()

Point

Properties	Status
Border	Hidden
Fill	Hidden
Interior	Hidden
PictureUnit	Hidden

Methods	Status
ApplyDataLabels	Changed VOID ApplyDataLabels (OPTIONAL XLDATALABELSTYPE Type = 2, OPTIONAL VARIANT LegendKey, OPTIONAL VARIANT AutoText) VARIANT ApplyDataLabels (OPTIONAL XLDATALABELSTYPE Type = 2, OPTIONAL VARIANT LegendKey, OPTIONAL VARIANT AutoText, OPTIONAL VARIANT HasLeaderLines, OPTIONAL VARIANT ShowSeriesName, OPTIONAL VARIANT ShowCategoryName, OPTIONAL VARIANT ShowValue, OPTIONAL VARIANT ShowPercentage, OPTIONAL VARIANT ShowBubbleSize, OPTIONAL VARIANT Separator)
ClearFormats	Changed VOID ClearFormats () VARIANT ClearFormats ()
Copy	Changed VOID Copy () VARIANT Copy ()
Delete	Changed VOID Delete () VARIANT Delete ()
Paste	Changed VOID Paste () VARIANT Paste ()
Select	Changed VOID Select () VARIANT Select ()

QueryTable

Properties	Status
HasAutoFormat	Hidden
Sql	Hidden
TablesOnlyFromHTML	Hidden

Range

Properties	Status
FormulaLabel	Hidden
Value	Changed READ-WRITE Value [VARIANT] READ-WRITE Value [VARIANT] (OPTIONAL VARIANT RangeValueDataType)

Methods	Status
Activate	Changed VOID Activate () VARIANT Activate ()
AdvancedFilter	Changed VOID AdvancedFilter (XLFILTERACTION Action, OPTIONAL VARIANT CriteriaRange, OPTIONAL VARIANT CopyToRange, OPTIONAL VARIANT Unique) VARIANT AdvancedFilter (XLFILTERACTION Action, OPTIONAL VARIANT CriteriaRange, OPTIONAL VARIANT CopyToRange, OPTIONAL VARIANT Unique)
ApplyNames	Changed VOID ApplyNames (OPTIONAL VARIANT Names, OPTIONAL VARIANT IgnoreRelativeAbsolute, OPTIONAL VARIANT UseRowColumnNames, OPTIONAL VARIANT OmitColumn, OPTIONAL VARIANT OmitRow, OPTIONAL XLAPPLYNAMESORDER Order = 1, OPTIONAL VARIANT AppendLast) VARIANT ApplyNames (OPTIONAL VARIANT Names, OPTIONAL VARIANT IgnoreRelativeAbsolute, OPTIONAL VARIANT UseRowColumnNames, OPTIONAL VARIANT OmitColumn, OPTIONAL VARIANT OmitRow, OPTIONAL XLAPPLYNAMESORDER Order = 1, OPTIONAL VARIANT AppendLast)
ApplyOutlineStyles	Changed VOID ApplyOutlineStyles () VARIANT ApplyOutlineStyles ()
AutoFill	Changed VOID AutoFill (RANGE Destination, OPTIONAL XLAUTOFILLTYPE Type = 0) VARIANT AutoFill (RANGE Destination, OPTIONAL XLAUTOFILLTYPE Type = 0)
AutoFilter	Changed VOID AutoFilter (OPTIONAL VARIANT Field, OPTIONAL VARIANT Criteria1, OPTIONAL XLAUTOFILTEROPERATOR Operator = 1, OPTIONAL VARIANT Criteria2, OPTIONAL VARIANT VisibleDropDown) VARIANT AutoFilter (OPTIONAL VARIANT Field, OPTIONAL VARIANT Criteria1, OPTIONAL XLAUTOFILTEROPERATOR Operator = 1, OPTIONAL VARIANT Criteria2, OPTIONAL VARIANT VisibleDropDown)
AutoFit	Changed VOID AutoFit () VARIANT AutoFit ()
AutoFormat	Hidden
AutoOutline	Changed VOID AutoOutline () VARIANT AutoOutline ()
BorderAround	Changed VOID BorderAround (OPTIONAL VARIANT LineStyle, OPTIONAL XLBORDERWEIGHT Weight = 2, OPTIONAL XLCOLORINDEX ColorIndex = -4105, OPTIONAL VARIANT Color) VARIANT BorderAround (OPTIONAL VARIANT LineStyle, OPTIONAL XLBORDERWEIGHT Weight = 2, OPTIONAL XLCOLORINDEX ColorIndex = -4105, OPTIONAL VARIANT Color)
Calculate	Changed VOID Calculate () VARIANT Calculate ()
CheckSpelling	Changed VOID CheckSpelling (OPTIONAL VARIANT CustomDictionary, OPTIONAL VARIANT IgnoreUppercase, OPTIONAL VARIANT AlwaysSuggest, OPTIONAL VARIANT IgnoreInitialAlefHamza, OPTIONAL VARIANT IgnoreFinalYaa, OPTIONAL VARIANT SpellScript) VARIANT CheckSpelling (OPTIONAL VARIANT CustomDictionary, OPTIONAL VARIANT IgnoreUppercase, OPTIONAL VARIANT AlwaysSuggest, OPTIONAL VARIANT SpellLang)
Clear	Changed VOID Clear () VARIANT Clear ()
ClearContents	Changed VOID ClearContents () VARIANT ClearContents ()
ClearFormats	Changed VOID ClearFormats () VARIANT ClearFormats ()
ClearNotes	Changed VOID ClearNotes () VARIANT ClearNotes ()
ClearOutline	Changed VOID ClearOutline () VARIANT ClearOutline ()
Consolidate	Changed VOID Consolidate (OPTIONAL VARIANT Sources, OPTIONAL VARIANT Function, OPTIONAL VARIANT TopRow, OPTIONAL VARIANT LeftColumn, OPTIONAL VARIANT CreateLinks) VARIANT Consolidate (OPTIONAL VARIANT Sources, OPTIONAL VARIANT Function, OPTIONAL VARIANT TopRow, OPTIONAL VARIANT LeftColumn, OPTIONAL VARIANT CreateLinks)
Copy	Changed VOID Copy (OPTIONAL VARIANT Destination) VARIANT Copy (OPTIONAL VARIANT Destination)
CopyPicture	Changed VOID CopyPicture (OPTIONAL XLPICTUREAPPEARANCE Appearance = 1, OPTIONAL XLCOPYPICTUREFORMAT Format = -4147) VARIANT CopyPicture (OPTIONAL XLPICTUREAPPEARANCE Appearance = 1, OPTIONAL XLCOPYPICTUREFORMAT Format = -4147)
CreateNames	Changed VOID CreateNames (OPTIONAL VARIANT Top, OPTIONAL VARIANT Left, OPTIONAL VARIANT Bottom, OPTIONAL VARIANT Right) VARIANT CreateNames (OPTIONAL VARIANT Top, OPTIONAL VARIANT Left, OPTIONAL VARIANT Bottom, OPTIONAL VARIANT Right)
CreatePublisher	Hidden
Cut	Changed VOID Cut (OPTIONAL VARIANT Destination) VARIANT Cut (OPTIONAL VARIANT Destination)
DataSeries	Changed VOID DataSeries (OPTIONAL VARIANT Rowcol, OPTIONAL XLDATASERIESTYPE Type = -4132, OPTIONAL XLDATASERIESDATE Date = 1, OPTIONAL VARIANT Step, OPTIONAL VARIANT Stop, OPTIONAL VARIANT Trend) VARIANT DataSeries (OPTIONAL VARIANT Rowcol, OPTIONAL XLDATASERIESTYPE Type = -4132, OPTIONAL XLDATASERIESDATE Date = 1, OPTIONAL VARIANT Step, OPTIONAL VARIANT Stop, OPTIONAL VARIANT Trend)
Delete	Changed VOID Delete (OPTIONAL VARIANT Shift) VARIANT Delete (OPTIONAL VARIANT Shift)
FillDown	Changed VOID FillDown () VARIANT FillDown ()
FillLeft	Changed VOID FillLeft () VARIANT FillLeft ()
FillRight	Changed VOID FillRight () VARIANT FillRight ()
FillUp	Changed VOID FillUp () VARIANT FillUp ()
Find	Changed RANGE Find (VARIANT What, OPTIONAL VARIANT After, OPTIONAL VARIANT LookIn, OPTIONAL VARIANT LookAt, OPTIONAL VARIANT SearchOrder, OPTIONAL XLSEARCHDIRECTION SearchDirection = 1, OPTIONAL VARIANT MatchCase, OPTIONAL VARIANT MatchByte, OPTIONAL VARIANT MatchControlCharacters, OPTIONAL VARIANT MatchDiacritics, OPTIONAL VARIANT MatchKashida, OPTIONAL VARIANT MatchAlefHamza) RANGE Find (VARIANT What, OPTIONAL VARIANT After, OPTIONAL VARIANT LookIn, OPTIONAL VARIANT LookAt, OPTIONAL VARIANT SearchOrder, OPTIONAL XLSEARCHDIRECTION SearchDirection = 1, OPTIONAL VARIANT MatchCase, OPTIONAL VARIANT MatchByte, OPTIONAL VARIANT SearchFormat)
FunctionWizard	Changed VOID FunctionWizard () VARIANT FunctionWizard ()
GoalSeek	Hidden
Insert	Changed VOID Insert (OPTIONAL VARIANT Shift) VARIANT Insert (OPTIONAL VARIANT Shift, OPTIONAL VARIANT CopyOrigin)
Justify	Changed VOID Justify () VARIANT Justify ()
ListNames	Changed VOID ListNames () VARIANT ListNames ()
NavigateArrow	Changed VOID NavigateArrow (OPTIONAL VARIANT TowardPrecedent, OPTIONAL VARIANT ArrowNumber, OPTIONAL VARIANT LinkNumber) VARIANT NavigateArrow (OPTIONAL VARIANT TowardPrecedent, OPTIONAL VARIANT ArrowNumber, OPTIONAL VARIANT LinkNumber)
Parse	Changed VOID Parse (OPTIONAL VARIANT ParseLine, OPTIONAL VARIANT Destination) VARIANT Parse (OPTIONAL VARIANT ParseLine, OPTIONAL VARIANT Destination)
PasteSpecial	Changed VOID PasteSpecial (OPTIONAL XLPASTETYPE Paste = -4104, OPTIONAL XLPASTESPECIALOPERATION Operation = -4142, OPTIONAL VARIANT SkipBlanks, OPTIONAL VARIANT Transpose) VARIANT PasteSpecial (OPTIONAL XLPASTETYPE Paste = -4104, OPTIONAL XLPASTESPECIALOPERATION Operation = -4142, OPTIONAL VARIANT SkipBlanks, OPTIONAL VARIANT Transpose)
PrintOut	Changed VOID PrintOut (OPTIONAL VARIANT From, OPTIONAL VARIANT To, OPTIONAL VARIANT Copies, OPTIONAL VARIANT Preview, OPTIONAL VARIANT ActivePrinter, OPTIONAL VARIANT PrintToFile, OPTIONAL VARIANT Collate) VARIANT PrintOut (OPTIONAL VARIANT From, OPTIONAL VARIANT To, OPTIONAL VARIANT Copies, OPTIONAL VARIANT Preview, OPTIONAL VARIANT ActivePrinter, OPTIONAL VARIANT PrintToFile, OPTIONAL VARIANT Collate, OPTIONAL VARIANT PrToFileName)
PrintPreview	Changed VOID PrintPreview (OPTIONAL VARIANT EnableChanges) VARIANT PrintPreview (OPTIONAL VARIANT EnableChanges)
RemoveSubtotal	Changed VOID RemoveSubtotal () VARIANT RemoveSubtotal ()
Replace	Changed BOOL Replace (VARIANT What, VARIANT Replacement, OPTIONAL VARIANT LookAt, OPTIONAL VARIANT SearchOrder, OPTIONAL VARIANT MatchCase, OPTIONAL VARIANT MatchByte, OPTIONAL VARIANT MatchControlCharacters, OPTIONAL VARIANT MatchDiacritics, OPTIONAL VARIANT MatchKashida, OPTIONAL VARIANT MatchAlefHamza) BOOL Replace (VARIANT What, VARIANT Replacement, OPTIONAL VARIANT LookAt, OPTIONAL VARIANT SearchOrder, OPTIONAL VARIANT MatchCase, OPTIONAL VARIANT MatchByte, OPTIONAL VARIANT SearchFormat, OPTIONAL VARIANT ReplaceFormat)
Select	Changed VOID Select () VARIANT Select ()
Show	Changed VOID Show () VARIANT Show ()
ShowDependents	Changed VOID ShowDependents (OPTIONAL VARIANT Remove) VARIANT ShowDependents (OPTIONAL VARIANT Remove)
ShowErrors	Changed VOID ShowErrors () VARIANT ShowErrors ()
ShowPrecedents	Changed VOID ShowPrecedents (OPTIONAL VARIANT Remove) VARIANT ShowPrecedents (OPTIONAL VARIANT Remove)
Sort	Changed VOID Sort (OPTIONAL VARIANT Key1, OPTIONAL XLSORTORDER Order1 = 1, OPTIONAL VARIANT Key2, OPTIONAL VARIANT Type, OPTIONAL XLSORTORDER Order2 = 1, OPTIONAL VARIANT Key3, OPTIONAL XLSORTORDER Order3 = 1, OPTIONAL XLYESNOGUESS Header = 2, OPTIONAL VARIANT OrderCustom, OPTIONAL VARIANT MatchCase, OPTIONAL XLSORTORIENTATION Orientation = 2, OPTIONAL XLSORTMETHOD SortMethod = 1, OPTIONAL VARIANT IgnoreControlCharacters, OPTIONAL VARIANT IgnoreDiacritics, OPTIONAL VARIANT IgnoreKashida) VARIANT Sort (OPTIONAL VARIANT Key1, OPTIONAL XLSORTORDER Order1 = 1, OPTIONAL VARIANT Key2, OPTIONAL VARIANT Type, OPTIONAL XLSORTORDER Order2 = 1, OPTIONAL VARIANT Key3, OPTIONAL XLSORTORDER Order3 = 1, OPTIONAL XLYESNOGUESS Header = 2, OPTIONAL VARIANT OrderCustom, OPTIONAL VARIANT MatchCase, OPTIONAL XLSORTORIENTATION Orientation = 2, OPTIONAL XLSORTMETHOD SortMethod = 1, OPTIONAL XLSORTDATAOPTION DataOption1 = 0, OPTIONAL XLSORTDATAOPTION DataOption2 = 0, OPTIONAL XLSORTDATAOPTION DataOption3 = 0)
SortSpecial	Changed VOID SortSpecial (OPTIONAL XLSORTMETHOD SortMethod = 1, OPTIONAL VARIANT Key1, OPTIONAL XLSORTORDER Order1 = 1, OPTIONAL VARIANT Type, OPTIONAL VARIANT Key2, OPTIONAL XLSORTORDER Order2 = 1, OPTIONAL VARIANT Key3, OPTIONAL XLSORTORDER Order3 = 1, OPTIONAL XLYESNOGUESS Header = 2, OPTIONAL VARIANT OrderCustom, OPTIONAL VARIANT MatchCase, OPTIONAL XLSORTORIENTATION Orientation = 2) VARIANT SortSpecial (OPTIONAL XLSORTMETHOD SortMethod = 1, OPTIONAL VARIANT Key1, OPTIONAL XLSORTORDER Order1 = 1, OPTIONAL VARIANT Type, OPTIONAL VARIANT Key2, OPTIONAL XLSORTORDER Order2 = 1, OPTIONAL VARIANT Key3, OPTIONAL XLSORTORDER Order3 = 1, OPTIONAL XLYESNOGUESS Header = 2, OPTIONAL VARIANT OrderCustom, OPTIONAL VARIANT MatchCase, OPTIONAL XLSORTORIENTATION Orientation = 2, OPTIONAL XLSORTDATAOPTION DataOption1 = 0, OPTIONAL XLSORTDATAOPTION DataOption2 = 0, OPTIONAL XLSORTDATAOPTION DataOption3 = 0)
SubscribeTo	Changed VOID SubscribeTo (STRING Edition, OPTIONAL XLSUBSCRIBETOFORMAT Format = -4158) VARIANT SubscribeTo (STRING Edition, OPTIONAL XLSUBSCRIBETOFORMAT Format = -4158)
Subtotal	Changed VOID Subtotal (INT32 GroupBy, XLCONSOLIDATIONFUNCTION Function, VARIANT TotalList, OPTIONAL VARIANT Replace, OPTIONAL VARIANT PageBreaks, OPTIONAL XLSUMMARYROW SummaryBelowData = 1) VARIANT Subtotal (INT32 GroupBy, XLCONSOLIDATIONFUNCTION Function, VARIANT TotalList, OPTIONAL VARIANT Replace, OPTIONAL VARIANT PageBreaks, OPTIONAL XLSUMMARYROW SummaryBelowData = 1)
Table	Changed VOID Table (OPTIONAL VARIANT RowInput, OPTIONAL VARIANT ColumnInput) VARIANT Table (OPTIONAL VARIANT RowInput, OPTIONAL VARIANT ColumnInput)
TextToColumns	Changed VOID TextToColumns (OPTIONAL VARIANT Destination, OPTIONAL XLTEXTPARSINGTYPE DataType = 1, OPTIONAL XLTEXTQUALIFIER TextQualifier = 1, OPTIONAL VARIANT ConsecutiveDelimiter, OPTIONAL VARIANT Tab, OPTIONAL VARIANT Semicolon, OPTIONAL VARIANT Comma, OPTIONAL VARIANT Space, OPTIONAL VARIANT Other, OPTIONAL VARIANT OtherChar, OPTIONAL VARIANT FieldInfo) VARIANT TextToColumns (OPTIONAL VARIANT Destination, OPTIONAL XLTEXTPARSINGTYPE DataType = 1, OPTIONAL XLTEXTQUALIFIER TextQualifier = 1, OPTIONAL VARIANT ConsecutiveDelimiter, OPTIONAL VARIANT Tab, OPTIONAL VARIANT Semicolon, OPTIONAL VARIANT Comma, OPTIONAL VARIANT Space, OPTIONAL VARIANT Other, OPTIONAL VARIANT OtherChar, OPTIONAL VARIANT FieldInfo, OPTIONAL VARIANT DecimalSeparator, OPTIONAL VARIANT ThousandsSeparator, OPTIONAL VARIANT TrailingMinusNumbers)
Ungroup	Changed VOID Ungroup () VARIANT Ungroup ()

RoutingSlip

Methods	Status
Recipients	Removed
Reset	Changed VOID Reset () VARIANT Reset ()

Scenario

Methods	Status
ChangeScenario	Changed VOID ChangeScenario (VARIANT ChangingCells, OPTIONAL VARIANT Values) VARIANT ChangeScenario (VARIANT ChangingCells, OPTIONAL VARIANT Values)
Delete	Changed VOID Delete () VARIANT Delete ()
Show	Changed VOID Show () VARIANT Show ()

Scenarios

Methods	Status
CreateSummary	Changed VOID CreateSummary (OPTIONAL XLSUMMARYREPORTTYPE ReportType = 1, OPTIONAL VARIANT ResultCells) VARIANT CreateSummary (OPTIONAL XLSUMMARYREPORTTYPE ReportType = 1, OPTIONAL VARIANT ResultCells)
Merge	Changed VOID Merge (VARIANT Source) VARIANT Merge (VARIANT Source)

Series

Properties	Status
Border	Hidden
Fill	Hidden
Interior	Hidden
PictureUnit	Hidden

Methods	Status
ApplyCustomType	Hidden
ApplyDataLabels	Changed VOID ApplyDataLabels (OPTIONAL XLDATALABELSTYPE Type = 2, OPTIONAL VARIANT LegendKey, OPTIONAL VARIANT AutoText, OPTIONAL VARIANT HasLeaderLines) VARIANT ApplyDataLabels (OPTIONAL XLDATALABELSTYPE Type = 2, OPTIONAL VARIANT LegendKey, OPTIONAL VARIANT AutoText, OPTIONAL VARIANT HasLeaderLines, OPTIONAL VARIANT ShowSeriesName, OPTIONAL VARIANT ShowCategoryName, OPTIONAL VARIANT ShowValue, OPTIONAL VARIANT ShowPercentage, OPTIONAL VARIANT ShowBubbleSize, OPTIONAL VARIANT Separator)
ClearFormats	Changed VOID ClearFormats () VARIANT ClearFormats ()
Copy	Changed VOID Copy () VARIANT Copy ()
Delete	Changed VOID Delete () VARIANT Delete ()
ErrorBar	Changed VOID ErrorBar (XLERRORBARDIRECTION Direction, XLERRORBARINCLUDE Include, XLERRORBARTYPE Type, OPTIONAL VARIANT Amount, OPTIONAL VARIANT MinusValues) VARIANT ErrorBar (XLERRORBARDIRECTION Direction, XLERRORBARINCLUDE Include, XLERRORBARTYPE Type, OPTIONAL VARIANT Amount, OPTIONAL VARIANT MinusValues)
Paste	Changed VOID Paste () VARIANT Paste ()
Select	Changed VOID Select () VARIANT Select ()

SeriesCollection

Methods	Status
Extend	Changed VOID Extend (VARIANT Source, OPTIONAL VARIANT Rowcol, OPTIONAL VARIANT CategoryLabels) VARIANT Extend (VARIANT Source, OPTIONAL VARIANT Rowcol, OPTIONAL VARIANT CategoryLabels)
Paste	Changed VOID Paste (OPTIONAL XLROWCOL Rowcol = 2, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace, OPTIONAL VARIANT NewSeries) VARIANT Paste (OPTIONAL XLROWCOL Rowcol = 2, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace, OPTIONAL VARIANT NewSeries)

SeriesLines

Methods	Status
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select () VARIANT Select ()

Sheets

PrintOut

Changed

VOID PrintOut (OPTIONAL VARIANT From, OPTIONAL VARIANT To, OPTIONAL VARIANT Copies, OPTIONAL VARIANT Preview, OPTIONAL VARIANT ActivePrinter, OPTIONAL VARIANT PrintToFile, OPTIONAL VARIANT Collate)

SoundNote

Methods	Status
Delete	Changed VOID Delete () VARIANT Delete ()
Import	Changed VOID Import (STRING Filename) VARIANT Import (STRING Filename)
Play	Changed VOID Play () VARIANT Play ()
Record	Changed VOID Record () VARIANT Record ()

Style

Methods	Status
Delete	Changed VOID Delete () VARIANT Delete ()

Styles

Methods	Status
Merge	Changed VOID Merge (VARIANT Workbook) VARIANT Merge (VARIANT Workbook)

TickLabels

Properties	Status
AutoScaleFont	Hidden

Methods	Status
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select () VARIANT Select ()

Trendline

Properties	Status
Backward	Hidden
Forward	Hidden

Methods	Status
ClearFormats	Changed VOID ClearFormats () VARIANT ClearFormats ()
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select () VARIANT Select ()

UpBars

Properties	Status
Border	Hidden
Fill	Hidden
Interior	Hidden

Methods	Status
Delete	Changed VOID Delete () VARIANT Delete ()
Select	Changed VOID Select () VARIANT Select ()

Walls

Properties	Status
Border	Hidden
Fill	Hidden
Interior	Hidden

Methods	Status
ClearFormats	Changed VOID ClearFormats () VARIANT ClearFormats ()
Select	Changed VOID Select () VARIANT Select ()

Window

Methods	Status
Activate	Changed VOID Activate () VARIANT Activate ()
ActivateNext	Changed VOID ActivateNext () VARIANT ActivateNext ()
ActivatePrevious	Changed VOID ActivatePrevious () VARIANT ActivatePrevious ()
Close	Changed VOID Close (OPTIONAL VARIANT SaveChanges, OPTIONAL VARIANT Filename, OPTIONAL VARIANT RouteWorkbook) BOOL Close (OPTIONAL VARIANT SaveChanges, OPTIONAL VARIANT Filename, OPTIONAL VARIANT RouteWorkbook)
LargeScroll	Changed VOID LargeScroll (OPTIONAL VARIANT Down, OPTIONAL VARIANT Up, OPTIONAL VARIANT ToRight, OPTIONAL VARIANT ToLeft) VARIANT LargeScroll (OPTIONAL VARIANT Down, OPTIONAL VARIANT Up, OPTIONAL VARIANT ToRight, OPTIONAL VARIANT ToLeft)
PrintOut	Changed VOID PrintOut (OPTIONAL VARIANT From, OPTIONAL VARIANT To, OPTIONAL VARIANT Copies, OPTIONAL VARIANT Preview, OPTIONAL VARIANT ActivePrinter, OPTIONAL VARIANT PrintToFile, OPTIONAL VARIANT Collate) VARIANT PrintOut (OPTIONAL VARIANT From, OPTIONAL VARIANT To, OPTIONAL VARIANT Copies, OPTIONAL VARIANT Preview, OPTIONAL VARIANT ActivePrinter, OPTIONAL VARIANT PrintToFile, OPTIONAL VARIANT Collate, OPTIONAL VARIANT PrToFileName)
PrintPreview	Changed VOID PrintPreview (OPTIONAL VARIANT EnableChanges) VARIANT PrintPreview (OPTIONAL VARIANT EnableChanges)
ScrollWorkbookTabs	Changed VOID ScrollWorkbookTabs (OPTIONAL VARIANT Sheets, OPTIONAL VARIANT Position) VARIANT ScrollWorkbookTabs (OPTIONAL VARIANT Sheets, OPTIONAL VARIANT Position)
SmallScroll	Changed VOID SmallScroll (OPTIONAL VARIANT Down, OPTIONAL VARIANT Up, OPTIONAL VARIANT ToRight, OPTIONAL VARIANT ToLeft) VARIANT SmallScroll (OPTIONAL VARIANT Down, OPTIONAL VARIANT Up, OPTIONAL VARIANT ToRight, OPTIONAL VARIANT ToLeft)

Windows

Methods	Status
Arrange	Changed VOID Arrange (OPTIONAL XLARRANGESTYLE ArrangeStyle = 1, OPTIONAL VARIANT ActiveWorkbook, OPTIONAL VARIANT SyncHorizontal, OPTIONAL VARIANT SyncVertical) VARIANT Arrange (OPTIONAL XLARRANGESTYLE ArrangeStyle = 1, OPTIONAL VARIANT ActiveWorkbook, OPTIONAL VARIANT SyncHorizontal, OPTIONAL VARIANT SyncVertical)

Workbook

Properties	Status
AcceptLabelsInFormulas	Hidden
CommandBars	Changed READ-ONLY CommandBars [_COMMANDBARS] READ-ONLY CommandBars [COMMANDBARS]
ConflictResolution	Changed READ-WRITE ConflictResolution [INT32] READ-WRITE ConflictResolution [XLSAVECONFLICTRESOLUTION]
DisplayDrawingObjects	Changed READ-WRITE DisplayDrawingObjects [XLDISPLAYSHAPES] READ-WRITE DisplayDrawingObjects [XLDISPLAYDRAWINGOBJECTS]
HasRoutingSlip	Hidden
ReadOnlyRecommended	Changed READ-ONLY ReadOnlyRecommended [BOOL] READ-WRITE ReadOnlyRecommended [BOOL]
Routed	Hidden
RoutingSlip	Hidden
VBProject	Changed READ-ONLY VBProject [unknown type] READ-ONLY VBProject [VBPROJECT]

Methods	Status
PrintOut	Changed VOID PrintOut (OPTIONAL VARIANT From, OPTIONAL VARIANT To, OPTIONAL VARIANT Copies, OPTIONAL VARIANT Preview, OPTIONAL VARIANT ActivePrinter, OPTIONAL VARIANT PrintToFile, OPTIONAL VARIANT Collate) VOID PrintOut (OPTIONAL VARIANT From, OPTIONAL VARIANT To, OPTIONAL VARIANT Copies, OPTIONAL VARIANT Preview, OPTIONAL VARIANT ActivePrinter, OPTIONAL VARIANT PrintToFile, OPTIONAL VARIANT Collate, OPTIONAL VARIANT PrToFileName, OPTIONAL VARIANT IgnorePrintAreas)
ProtectSharing	Changed VOID ProtectSharing (OPTIONAL VARIANT Filename, OPTIONAL VARIANT Password, OPTIONAL VARIANT WriteResPassword, OPTIONAL VARIANT ReadOnlyRecommended, OPTIONAL VARIANT CreateBackup, OPTIONAL VARIANT SharingPassword) VOID ProtectSharing (OPTIONAL VARIANT Filename, OPTIONAL VARIANT Password, OPTIONAL VARIANT WriteResPassword, OPTIONAL VARIANT ReadOnlyRecommended, OPTIONAL VARIANT CreateBackup, OPTIONAL VARIANT SharingPassword, OPTIONAL VARIANT FileFormat)
Route	Hidden
SaveAs	Changed VOID SaveAs (OPTIONAL VARIANT Filename, OPTIONAL VARIANT FileFormat, OPTIONAL VARIANT Password, OPTIONAL VARIANT WriteResPassword, OPTIONAL VARIANT ReadOnlyRecommended, OPTIONAL VARIANT CreateBackup, OPTIONAL XLSAVEASACCESSMODE AccessMode = 1, OPTIONAL VARIANT ConflictResolution, OPTIONAL VARIANT AddToMru, OPTIONAL VARIANT TextCodepage, OPTIONAL VARIANT TextVisualLayout) VOID SaveAs (OPTIONAL VARIANT Filename, OPTIONAL VARIANT FileFormat, OPTIONAL VARIANT Password, OPTIONAL VARIANT WriteResPassword, OPTIONAL VARIANT ReadOnlyRecommended, OPTIONAL VARIANT CreateBackup, OPTIONAL XLSAVEASACCESSMODE AccessMode = 1, OPTIONAL VARIANT ConflictResolution, OPTIONAL VARIANT AddToMru, OPTIONAL VARIANT TextCodepage, OPTIONAL VARIANT TextVisualLayout, OPTIONAL VARIANT Local)

Workbooks

Open

Changed

WORKBOOK Open (STRING Filename, OPTIONAL VARIANT UpdateLinks, OPTIONAL VARIANT ReadOnly, OPTIONAL VARIANT Format, OPTIONAL VARIANT Password, OPTIONAL VARIANT WriteResPassword, OPTIONAL VARIANT IgnoreReadOnlyRecommended, OPTIONAL VARIANT Origin, OPTIONAL VARIANT Delimiter, OPTIONAL VARIANT Editable, OPTIONAL VARIANT Notify, OPTIONAL VARIANT Converter, OPTIONAL VARIANT AddToMru)

OpenText

Changed

VOID OpenText (STRING Filename, OPTIONAL VARIANT Origin, OPTIONAL VARIANT StartRow, OPTIONAL VARIANT DataType, OPTIONAL XLTEXTQUALIFIER TextQualifier = 1, OPTIONAL VARIANT ConsecutiveDelimiter, OPTIONAL VARIANT Tab, OPTIONAL VARIANT Semicolon, OPTIONAL VARIANT Comma, OPTIONAL VARIANT Space, OPTIONAL VARIANT Other, OPTIONAL VARIANT OtherChar, OPTIONAL VARIANT FieldInfo, OPTIONAL VARIANT TextVisualLayout)

Worksheet

Methods	Status
CheckSpelling	Changed VOID CheckSpelling (OPTIONAL VARIANT CustomDictionary, OPTIONAL VARIANT IgnoreUppercase, OPTIONAL VARIANT AlwaysSuggest, OPTIONAL VARIANT IgnoreInitialAlefHamza, OPTIONAL VARIANT IgnoreFinalYaa, OPTIONAL VARIANT SpellScript) VOID CheckSpelling (OPTIONAL VARIANT CustomDictionary, OPTIONAL VARIANT IgnoreUppercase, OPTIONAL VARIANT AlwaysSuggest, OPTIONAL VARIANT SpellLang)
PasteSpecial	Changed VOID PasteSpecial (OPTIONAL VARIANT Format, OPTIONAL VARIANT Link, OPTIONAL VARIANT DisplayAsIcon, OPTIONAL VARIANT IconFileName, OPTIONAL VARIANT IconIndex, OPTIONAL VARIANT IconLabel) VOID PasteSpecial (OPTIONAL VARIANT Format, OPTIONAL VARIANT Link, OPTIONAL VARIANT DisplayAsIcon, OPTIONAL VARIANT IconFileName, OPTIONAL VARIANT IconIndex, OPTIONAL VARIANT IconLabel, OPTIONAL VARIANT NoHTMLFormatting)
PrintOut	Changed VOID PrintOut (OPTIONAL VARIANT From, OPTIONAL VARIANT To, OPTIONAL VARIANT Copies, OPTIONAL VARIANT Preview, OPTIONAL VARIANT ActivePrinter, OPTIONAL VARIANT PrintToFile, OPTIONAL VARIANT Collate) VOID PrintOut (OPTIONAL VARIANT From, OPTIONAL VARIANT To, OPTIONAL VARIANT Copies, OPTIONAL VARIANT Preview, OPTIONAL VARIANT ActivePrinter, OPTIONAL VARIANT PrintToFile, OPTIONAL VARIANT Collate, OPTIONAL VARIANT PrToFileName, OPTIONAL VARIANT IgnorePrintAreas)
Protect	Changed VOID Protect (OPTIONAL VARIANT Password, OPTIONAL VARIANT DrawingObjects, OPTIONAL VARIANT Contents, OPTIONAL VARIANT Scenarios, OPTIONAL VARIANT UserInterfaceOnly) VOID Protect (OPTIONAL VARIANT Password, OPTIONAL VARIANT DrawingObjects, OPTIONAL VARIANT Contents, OPTIONAL VARIANT Scenarios, OPTIONAL VARIANT UserInterfaceOnly, OPTIONAL VARIANT AllowFormattingCells, OPTIONAL VARIANT AllowFormattingColumns, OPTIONAL VARIANT AllowFormattingRows, OPTIONAL VARIANT AllowInsertingColumns, OPTIONAL VARIANT AllowInsertingRows, OPTIONAL VARIANT AllowInsertingHyperlinks, OPTIONAL VARIANT AllowDeletingColumns, OPTIONAL VARIANT AllowDeletingRows, OPTIONAL VARIANT AllowSorting, OPTIONAL VARIANT AllowFiltering, OPTIONAL VARIANT AllowUsingPivotTables)
SaveAs	Changed VOID SaveAs (STRING Filename, OPTIONAL VARIANT FileFormat, OPTIONAL VARIANT Password, OPTIONAL VARIANT WriteResPassword, OPTIONAL VARIANT ReadOnlyRecommended, OPTIONAL VARIANT CreateBackup, OPTIONAL VARIANT AddToMru, OPTIONAL VARIANT TextCodepage, OPTIONAL VARIANT TextVisualLayout) VOID SaveAs (STRING Filename, OPTIONAL VARIANT FileFormat, OPTIONAL VARIANT Password, OPTIONAL VARIANT WriteResPassword, OPTIONAL VARIANT ReadOnlyRecommended, OPTIONAL VARIANT CreateBackup, OPTIONAL VARIANT AddToMru, OPTIONAL VARIANT TextCodepage, OPTIONAL VARIANT TextVisualLayout, OPTIONAL VARIANT Local)

Worksheets

PrintOut

Changed

VOID PrintOut (OPTIONAL VARIANT From, OPTIONAL VARIANT To, OPTIONAL VARIANT Copies, OPTIONAL VARIANT Preview, OPTIONAL VARIANT ActivePrinter, OPTIONAL VARIANT PrintToFile, OPTIONAL VARIANT Collate)

XlDisplayShapes

Constants	Status
XlDisplayShapes	Removed
xlHide	Removed
xlPlaceholders	Removed

AI Skills Fest

Share via

Object Model Changes Since Microsoft Office 97

ChartColorFormat

ChartFillFormat

Corners

XlDisplayShapes

Additional resources