Object Model Changes Since Microsoft Office 2000
| 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