Object Model Changes Since Microsoft Office 2000
Office 2007
| Excel Developer Reference |
The following is a summary of the changes in the Microsoft Office Excel 2007 object model as compared to Microsoft Office 2000.
Application
| Properties | Status |
|---|---|
| FileFind | Hidden |
| FileSearch | Hidden |
| MemoryFree | Hidden |
| MemoryTotal | Hidden |
| MemoryUsed | Hidden |
| Methods | Status |
|---|---|
| AddChartAutoFormat | Hidden |
| DeleteChartAutoFormat | Hidden |
| SetDefaultChart | Hidden |
AxisTitle
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
| Border | Hidden |
| Fill | Hidden |
| Font | Hidden |
| Interior | Hidden |
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) |
Chart
| 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 |
ChartArea
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
| Border | Hidden |
| Fill | Hidden |
| Font | Hidden |
| Interior | Hidden |
ChartColorFormat
Hidden
ChartFillFormat
Hidden
ChartObject
| Properties | Status |
|---|---|
| Border | Hidden |
| Enabled | Hidden |
| Interior | Hidden |
ChartObjects
| Properties | Status |
|---|---|
| Border | Hidden |
| Enabled | Hidden |
| Interior | Hidden |
| RoundedCorners | Hidden |
| Shadow | Hidden |
| Methods | Status |
|---|---|
| BringToFront | Hidden |
| SendToBack | Hidden |
ChartTitle
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
| Border | Hidden |
| Fill | Hidden |
| Font | Hidden |
| Interior | Hidden |
Corners
Hidden
CubeField
| Properties | Status |
|---|---|
| Caption | Changed READ-ONLY Caption [STRING] READ-WRITE Caption [STRING] |
| HiddenLevels | Hidden |
DataLabel
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
| Border | Hidden |
| Fill | Hidden |
| Font | Hidden |
| Interior | Hidden |
| Type | Hidden |
DataLabels
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
| Border | Hidden |
| Fill | Hidden |
| Font | Hidden |
| Interior | Hidden |
| Type | Hidden |
DataTable
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
DisplayUnitLabel
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
| Border | Hidden |
| Fill | Hidden |
| Font | Hidden |
| Interior | Hidden |
DownBars
| Properties | Status |
|---|---|
| Border | Hidden |
| Fill | Hidden |
| Interior | Hidden |
Filter
| Properties | Status |
|---|---|
| Operator | Changed READ-ONLY Operator [XLAUTOFILTEROPERATOR] READ-WRITE Operator [XLAUTOFILTEROPERATOR] |
Floor
| Properties | Status |
|---|---|
| Border | Hidden |
| Fill | Hidden |
| Interior | Hidden |
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) |
Legend
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
| Border | Hidden |
| Fill | Hidden |
| Font | Hidden |
| Interior | Hidden |
LegendEntry
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
LegendKey
| Properties | Status |
|---|---|
| Border | Hidden |
| Fill | Hidden |
| Interior | Hidden |
| PictureUnit | Hidden |
| Methods | Status |
|---|---|
| Select | Hidden |
OLEObject
| Properties | Status |
|---|---|
| AltHTML | Hidden |
PageSetup
| Properties | Status |
|---|---|
| ChartSize | Hidden |
PivotCache
| 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) |
PivotCaches
| Methods | Status |
|---|---|
| Add | Hidden |
PivotField
| Methods | Status |
|---|---|
| AutoSort | Changed VOID AutoSort (INT32 Order, STRING Field) VOID AutoSort (INT32 Order, STRING Field, OPTIONAL VARIANT PivotLine, OPTIONAL VARIANT CustomSubtotal) |
PivotFormulas
| Methods | Status |
|---|---|
| Add | Changed PIVOTFORMULA Add (STRING Formula) PIVOTFORMULA Add (STRING Formula, OPTIONAL VARIANT UseStandardFormula) |
PivotLayout
| 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 |
PivotTable
| 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) |
PivotTables
| 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) |
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 |
Point
| 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) |
QueryTable
| Properties | Status |
|---|---|
| TextFilePlatform | Changed READ-WRITE TextFilePlatform [XLPLATFORM] READ-WRITE TextFilePlatform [INT32] |
Range
| 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) |
Series
| Properties | Status |
|---|---|
| Border | Hidden |
| Fill | Hidden |
| Interior | Hidden |
| PictureUnit | Hidden |
| Methods | Status |
|---|---|
| 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) |
Shape
| Properties | Status |
|---|---|
| Script | Hidden |
Sheets
| 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) |
TickLabels
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
Trendline
| Properties | Status |
|---|---|
| Backward | Hidden |
| Forward | Hidden |
UpBars
| Properties | Status |
|---|---|
| Border | Hidden |
| Fill | Hidden |
| Interior | Hidden |
Walls
| Properties | Status |
|---|---|
| Border | Hidden |
| Fill | Hidden |
| Interior | Hidden |
Workbook
| 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) |
Workbooks
| Methods | Status |
|---|---|
| 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) |
Worksheet
| 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) |
Worksheets
| 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) |
XlDisplayShapes
Removed
