Object Model Changes Since Microsoft Office 2000 [Excel 2007 Developer Reference]

Excel Developer Reference

Properties	Status
FileFind	Hidden
FileSearch	Hidden
MemoryFree	Hidden
MemoryTotal	Hidden
MemoryUsed	Hidden

Methods	Status
AddChartAutoFormat	Hidden
DeleteChartAutoFormat	Hidden
SetDefaultChart	Hidden

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

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

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

Properties	Status
Area3DGroup	Hidden
Bar3DGroup	Hidden
Column3DGroup	Hidden
Corners	Hidden
HasPivotFields	Hidden
Line3DGroup	Hidden
Pie3DGroup	Hidden
ProtectGoalSeek	Hidden
Scripts	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
ColumnGroups	Hidden
CreatePublisher	Hidden
Deselect	Hidden
DoughnutGroups	Hidden
LineGroups	Hidden
PieGroups	Hidden
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
DragOver	Hidden
DragPlot	Hidden

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

Properties	Status
Border	Hidden
Enabled	Hidden
Interior	Hidden

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

Methods	Status
BringToFront	Hidden
SendToBack	Hidden

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

Properties	Status
Caption	Changed READ-ONLY Caption [STRING] READ-WRITE Caption [STRING]
HiddenLevels	Hidden

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

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

Properties	Status
AutoScaleFont	Hidden

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

Properties	Status
Border	Hidden
Fill	Hidden
Interior	Hidden

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

Properties	Status
Border	Hidden
Fill	Hidden
Interior	Hidden

Properties	Status
OutlineFont	Hidden
Shadow	Hidden

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)

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)

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

Properties	Status
AutoScaleFont	Hidden

Properties	Status
Border	Hidden
Fill	Hidden
Interior	Hidden
PictureUnit	Hidden

Methods	Status
Select	Hidden

Properties	Status
AltHTML	Hidden

Properties	Status
ChartSize	Hidden

Methods	Status
CreatePivotTable	Changed PIVOTTABLE CreatePivotTable (VARIANT TableDestination, OPTIONAL VARIANT TableName, OPTIONAL VARIANT ReadData) PIVOTTABLE CreatePivotTable (VARIANT TableDestination, OPTIONAL VARIANT TableName, OPTIONAL VARIANT ReadData, OPTIONAL VARIANT DefaultVersion)

Methods	Status
Add	Hidden

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

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

Properties	Status
ColumnFields	Hidden
CubeFields	Hidden
DataFields	Hidden
HiddenFields	Hidden
InnerDetail	Hidden
PageFields	Hidden
PivotCache	Hidden
PivotFields	Hidden
RowFields	Hidden
VisibleFields	Hidden

Methods	Status
AddFields	Hidden

Properties	Status
HasAutoFormat	Hidden
TableStyle	Hidden

Methods	Status
Format	Hidden
PivotSelect	Changed VOID PivotSelect (STRING Name, OPTIONAL XLPTSELECTIONMODE Mode = 0) VOID PivotSelect (STRING Name, OPTIONAL XLPTSELECTIONMODE Mode = 0, OPTIONAL VARIANT UseStandardName)

Methods	Status
Add	Changed PIVOTTABLE Add (PIVOTCACHE PivotCache, VARIANT TableDestination, OPTIONAL VARIANT TableName, OPTIONAL VARIANT ReadData) PIVOTTABLE Add (PIVOTCACHE PivotCache, VARIANT TableDestination, OPTIONAL VARIANT TableName, OPTIONAL VARIANT ReadData, OPTIONAL VARIANT DefaultVersion)

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

Properties	Status
Border	Hidden
Fill	Hidden
Interior	Hidden
PictureUnit	Hidden

Methods	Status
ApplyDataLabels	Changed VARIANT 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)

ApplyDataLabels

Changed

VARIANT 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)

Properties	Status
TextFilePlatform	Changed READ-WRITE TextFilePlatform [XLPLATFORM] READ-WRITE TextFilePlatform [INT32]

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

Methods	Status
AutoFormat	Hidden
CreatePublisher	Hidden
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) 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)
GoalSeek	Hidden
Insert	Changed VARIANT Insert (OPTIONAL VARIANT Shift) VARIANT Insert (OPTIONAL VARIANT Shift, OPTIONAL VARIANT CopyOrigin)
Replace	Changed BOOL Replace (VARIANT What, VARIANT Replacement, OPTIONAL VARIANT LookAt, OPTIONAL VARIANT SearchOrder, OPTIONAL VARIANT MatchCase, OPTIONAL VARIANT MatchByte) BOOL Replace (VARIANT What, VARIANT Replacement, OPTIONAL VARIANT LookAt, OPTIONAL VARIANT SearchOrder, OPTIONAL VARIANT MatchCase, OPTIONAL VARIANT MatchByte, OPTIONAL VARIANT SearchFormat, OPTIONAL VARIANT ReplaceFormat)
Sort	Changed 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) 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 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) 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)
TextToColumns	Changed 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) 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)

Properties	Status
Border	Hidden
Fill	Hidden
Interior	Hidden
PictureUnit	Hidden

ApplyCustomType

Hidden

ApplyDataLabels

Changed

VARIANT 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)

Properties	Status
Script	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, OPTIONAL VARIANT PrToFileName)

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)

Properties	Status
AutoScaleFont	Hidden

Properties	Status
Backward	Hidden
Forward	Hidden

Properties	Status
Border	Hidden
Fill	Hidden
Interior	Hidden

Properties	Status
Border	Hidden
Fill	Hidden
Interior	Hidden

Properties	Status
AcceptLabelsInFormulas	Hidden
HasRoutingSlip	Hidden
HTMLProject	Hidden
ReadOnlyRecommended	Changed READ-ONLY ReadOnlyRecommended [BOOL] READ-WRITE ReadOnlyRecommended [BOOL]
Routed	Hidden
RoutingSlip	Hidden

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, OPTIONAL VARIANT PrToFileName) 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)

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)

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, OPTIONAL VARIANT Local, OPTIONAL VARIANT CorruptLoad)

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, OPTIONAL VARIANT DecimalSeparator, OPTIONAL VARIANT ThousandsSeparator)

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, OPTIONAL VARIANT DecimalSeparator, OPTIONAL VARIANT ThousandsSeparator, OPTIONAL VARIANT TrailingMinusNumbers, OPTIONAL VARIANT Local)

Properties	Status
Scripts	Hidden

Methods	Status
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, OPTIONAL VARIANT PrToFileName) 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)

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, OPTIONAL VARIANT PrToFileName)

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)

AI Skills Fest

Share via

Object Model Changes Since Microsoft Office 2000

ChartColorFormat

ChartFillFormat

Corners

XlDisplayShapes

Additional resources