Excel 2010 Object Model Changes Since Earlier Versions

  • Article

The tables in this topic provide a summary of the changes in the Microsoft Excel 2010 object model as compared to earlier versions of Microsoft Office.

Note

In these tables, the status value for a given object model member may be any of the following:

  • Changed—The syntax for the member has changed.

  • Hidden—The member has been deprecated.

  • Removed—The member has been removed from the object model.

Contents

  • Object Model Changes Since Microsoft Office 2007

  • Object Model Changes Since Microsoft Office 2003

  • Object Model Changes Since Microsoft Office XP (2002)

  • Object Model Changes Since Microsoft Office 2000

Object Model Changes Since Microsoft Office 2007

AboveAverage

Properties

Status

FormatRow

Removed

Application

Properties

Status

AnswerWizard

Hidden

Assistant

Hidden

SmartTagRecognizers

Hidden

Methods

Status

MacroOptions

Changed
Previous syntax
VOID MacroOptions (OPTIONAL VARIANT Macro, OPTIONAL VARIANT Description, OPTIONAL VARIANT HasMenu, OPTIONAL VARIANT MenuText, OPTIONAL VARIANT HasShortcutKey, OPTIONAL VARIANT ShortcutKey, OPTIONAL VARIANT Category, OPTIONAL VARIANT StatusBar, OPTIONAL VARIANT HelpContextID, OPTIONAL VARIANT HelpFile)
New syntax
VOID MacroOptions (OPTIONAL VARIANT Macro, OPTIONAL VARIANT Description, OPTIONAL VARIANT HasMenu, OPTIONAL VARIANT MenuText, OPTIONAL VARIANT HasShortcutKey, OPTIONAL VARIANT ShortcutKey, OPTIONAL VARIANT Category, OPTIONAL VARIANT StatusBar, OPTIONAL VARIANT HelpContextID, OPTIONAL VARIANT HelpFile, OPTIONAL VARIANT ArgumentDescriptions)

CalculatedMembers

Methods

Status

Add

Changed
Previous syntax
CALCULATEDMEMBER Add (STRING Name, STRING Formula, OPTIONAL VARIANT SolveOrder, OPTIONAL VARIANT Type)
New syntax
CALCULATEDMEMBER Add (STRING Name, VARIANT Formula, OPTIONAL VARIANT SolveOrder, OPTIONAL VARIANT Type, OPTIONAL VARIANT Dynamic, OPTIONAL VARIANT DisplayFolder, OPTIONAL VARIANT HierarchizeDistinct)

ColorScale

Properties

Status

FormatRow

Removed

FormatCondition

Properties

Status

FormatRow

Removed

IconSetCondition

Properties

Status

FormatRow

Removed

Range

Properties

Status

SmartTags

Hidden

Methods

Status

BorderAround

Changed
Previous syntax
VARIANT BorderAround (OPTIONAL VARIANT LineStyle, OPTIONAL XLBORDERWEIGHT Weight = 2, OPTIONAL XLCOLORINDEX ColorIndex = -4105, OPTIONAL VARIANT Color)
New syntax
VARIANT BorderAround (OPTIONAL VARIANT LineStyle, OPTIONAL XLBORDERWEIGHT Weight = 2, OPTIONAL XLCOLORINDEX ColorIndex = -4105, OPTIONAL VARIANT Color, OPTIONAL VARIANT ThemeColor)

SeriesCollection

Methods

Status

Add

Changed
Previous syntax
SERIES Add (VARIANT Source, OPTIONAL XLROWCOL Rowcol = 2, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace)
New syntax
SERIES Add (VARIANT Source, OPTIONAL XLROWCOL Rowcol = -4105, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace)

Paste

Changed
Previous syntax
VARIANT Paste (OPTIONAL XLROWCOL Rowcol = 2, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace, OPTIONAL VARIANT NewSeries)
New syntax
VARIANT Paste (OPTIONAL XLROWCOL Rowcol = -4105, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace, OPTIONAL VARIANT NewSeries)

SmartTag

Properties

Status

Application

Hidden

Creator

Hidden

DownloadURL

Hidden

Name

Hidden

Parent

Hidden

Properties

Hidden

Range

Hidden

SmartTagActions

Hidden

XML

Hidden

Methods

Status

Delete

Hidden

SmartTagAction

Properties

Status

ActiveXControl

Hidden

Application

Hidden

CheckboxState

Hidden

Creator

Hidden

ExpandHelp

Hidden

ListSelection

Hidden

Name

Hidden

Parent

Hidden

PresentInPane

Hidden

RadioGroupSelection

Hidden

TextboxText

Hidden

Type

Hidden

Methods

Status

Execute

Hidden

SmartTagActions

Properties

Status

Application

Hidden

Count

Hidden

Creator

Hidden

Item

Hidden

Parent

Hidden

SmartTagOptions

Properties

Status

Application

Hidden

Creator

Hidden

DisplaySmartTags

Hidden

EmbedSmartTags

Hidden

Parent

Hidden

SmartTagRecognizer

Properties

Status

Application

Hidden

Creator

Hidden

Enabled

Hidden

FullName

Hidden

Parent

Hidden

progID

Hidden

SmartTagRecognizers

Properties

Status

Application

Hidden

Count

Hidden

Creator

Hidden

Item

Hidden

Parent

Hidden

Recognize

Hidden

SmartTags

Properties

Status

Application

Hidden

Count

Hidden

Creator

Hidden

Parent

Hidden

Methods

Status

Add

Hidden

Top10

Properties

Status

FormatRow

Removed

UniqueValues

Properties

Status

FormatRow

Removed

Workbook

Properties

Status

SmartTagOptions

Hidden

Methods

Status

CheckIn

Changed
Previous syntax
VOID CheckIn (OPTIONAL VARIANT SaveChanges, OPTIONAL VARIANT Comments, OPTIONAL VARIANT MakePublic, OPTIONAL VARIANT VersionType)
New syntax
VOID CheckIn (OPTIONAL VARIANT SaveChanges, OPTIONAL VARIANT Comments, OPTIONAL VARIANT MakePublic)

RecheckSmartTags

Hidden

Worksheet

Properties

Status

SmartTags

Hidden

XlRobustSave

Constants

Status

xlMinimalSave

Removed

xlNormalSave

Removed

xlSafeSave

Removed

Object Model Changes Since Microsoft Office 2003

Application

Properties

Status

AnswerWizard

Hidden

Assistant

Hidden

FileFind

Hidden

FileSearch

Hidden

SmartTagRecognizers

Hidden

Methods

Status

AddChartAutoFormat

Hidden

DeleteChartAutoFormat

Hidden

MacroOptions

Changed
Previous syntax
VOID MacroOptions (OPTIONAL VARIANT Macro, OPTIONAL VARIANT Description, OPTIONAL VARIANT HasMenu, OPTIONAL VARIANT MenuText, OPTIONAL VARIANT HasShortcutKey, OPTIONAL VARIANT ShortcutKey, OPTIONAL VARIANT Category, OPTIONAL VARIANT StatusBar, OPTIONAL VARIANT HelpContextID, OPTIONAL VARIANT HelpFile)
New syntax
VOID MacroOptions (OPTIONAL VARIANT Macro, OPTIONAL VARIANT Description, OPTIONAL VARIANT HasMenu, OPTIONAL VARIANT MenuText, OPTIONAL VARIANT HasShortcutKey, OPTIONAL VARIANT ShortcutKey, OPTIONAL VARIANT Category, OPTIONAL VARIANT StatusBar, OPTIONAL VARIANT HelpContextID, OPTIONAL VARIANT HelpFile, OPTIONAL VARIANT ArgumentDescriptions)

SetDefaultChart

Hidden

AxisTitle

Properties

Status

AutoScaleFont

Hidden

Border

Hidden

Fill

Hidden

Font

Hidden

Interior

Hidden

CalculatedMembers

Methods

Status

Add

Changed
Previous syntax
CALCULATEDMEMBER Add (STRING Name, STRING Formula, OPTIONAL VARIANT SolveOrder, OPTIONAL VARIANT Type)
New syntax
CALCULATEDMEMBER Add (STRING Name, VARIANT Formula, OPTIONAL VARIANT SolveOrder, OPTIONAL VARIANT Type, OPTIONAL VARIANT Dynamic, OPTIONAL VARIANT DisplayFolder, OPTIONAL VARIANT HierarchizeDistinct)

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

AreaGroups

Hidden

BarGroups

Hidden

ColumnGroups

Hidden

CreatePublisher

Hidden

Deselect

Hidden

DoughnutGroups

Hidden

LineGroups

Hidden

PieGroups

Hidden

RadarGroups

Hidden

XYGroups

Hidden

Events

Status

DragOver

Hidden

DragPlot

Hidden

ChartArea

Properties

Status

AutoScaleFont

Hidden

Border

Hidden

Fill

Hidden

Font

Hidden

Interior

Hidden

ChartColorFormat

Properties

Status

Application

Hidden

Creator

Hidden

Parent

Hidden

RGB

Hidden

SchemeColor

Hidden

Type

Hidden

ChartFillFormat

Properties

Status

Application

Hidden

BackColor

Hidden

Creator

Hidden

ForeColor

Hidden

GradientColorType

Hidden

GradientDegree

Hidden

GradientStyle

Hidden

GradientVariant

Hidden

Parent

Hidden

Pattern

Hidden

PresetGradientType

Hidden

PresetTexture

Hidden

TextureName

Hidden

TextureType

Hidden

Type

Hidden

Visible

Hidden

Methods

Status

OneColorGradient

Hidden

Patterned

Hidden

PresetGradient

Hidden

PresetTextured

Hidden

Solid

Hidden

TwoColorGradient

Hidden

UserPicture

Hidden

UserTextured

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

Properties

Status

Application

Hidden

Creator

Hidden

Name

Hidden

Parent

Hidden

Methods

Status

Select

Hidden

CubeField

Properties

Status

Caption

Changed
Previous syntax
READ-ONLY Caption [STRING]
New syntax
READ-WRITE Caption [STRING]

HiddenLevels

Hidden

Methods

Status

AddMemberPropertyField

Changed
Previous syntax
VOID AddMemberPropertyField (STRING Property, OPTIONAL VARIANT PropertyOrder)
New syntax
VOID AddMemberPropertyField (STRING Property, OPTIONAL VARIANT PropertyOrder, OPTIONAL VARIANT PropertyDisplayedIn)

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

Diagram

Properties

Status

Application

Hidden

AutoFormat

Hidden

AutoLayout

Hidden

Creator

Hidden

Nodes

Hidden

Parent

Hidden

Reverse

Hidden

Type

Hidden

Methods

Status

Convert

Hidden

FitText

Hidden

DiagramNode

Properties

Status

Application

Hidden

Children

Hidden

Creator

Hidden

Diagram

Hidden

Layout

Hidden

Parent

Hidden

Root

Hidden

Shape

Hidden

TextShape

Hidden

Methods

Status

AddNode

Hidden

CloneNode

Hidden

Delete

Hidden

MoveNode

Hidden

NextNode

Hidden

PrevNode

Hidden

ReplaceNode

Hidden

SwapNode

Hidden

TransferChildren

Hidden

DiagramNodeChildren

Properties

Status

Application

Hidden

Count

Hidden

Creator

Hidden

FirstChild

Hidden

LastChild

Hidden

Parent

Hidden

Methods

Status

AddNode

Hidden

Item

Hidden

SelectAll

Hidden

DiagramNodes

Properties

Status

Application

Hidden

Count

Hidden

Creator

Hidden

Parent

Hidden

Methods

Status

Item

Hidden

SelectAll

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
Previous syntax
READ-ONLY Operator [XLAUTOFILTEROPERATOR]
New syntax
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
Previous syntax
VOID Modify (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2)
New syntax
VOID Modify (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2, OPTIONAL VARIANT String, OPTIONAL VARIANT Operator2)

FormatConditions

Methods

Status

Add

Changed
Previous syntax
FORMATCONDITION Add (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2)
New syntax
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
Previous syntax
FORMATCONDITION Item (VARIANT Index)
New syntax
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

ListColumn

Properties

Status

ListDataFormat

Hidden

SharePointFormula

Hidden

ListObject

Methods

Status

UpdateChanges

Hidden

ListObjects

Methods

Status

Add

Changed
Previous syntax
LISTOBJECT Add (OPTIONAL XLLISTOBJECTSOURCETYPE SourceType = 1, OPTIONAL VARIANT Source, OPTIONAL VARIANT LinkSource, OPTIONAL XLYESNOGUESS XlListObjectHasHeaders = 0, OPTIONAL VARIANT Destination)
New syntax
LISTOBJECT Add (OPTIONAL XLLISTOBJECTSOURCETYPE SourceType = 1, OPTIONAL VARIANT Source, OPTIONAL VARIANT LinkSource, OPTIONAL XLYESNOGUESS XlListObjectHasHeaders = 0, OPTIONAL VARIANT Destination, OPTIONAL VARIANT TableStyleName)

ListRow

Properties

Status

InvalidData

Hidden

ListRows

Methods

Status

Add

Changed
Previous syntax
LISTROW Add (OPTIONAL VARIANT Position)
New syntax
LISTROW Add (OPTIONAL VARIANT Position, OPTIONAL VARIANT AlwaysInsert)

PageSetup

Properties

Status

ChartSize

Hidden

PivotCaches

Methods

Status

Add

Hidden

PivotField

Methods

Status

AutoSort

Changed
Previous syntax
VOID AutoSort (INT32 Order, STRING Field)
New syntax
VOID AutoSort (INT32 Order, STRING Field, OPTIONAL VARIANT PivotLine, OPTIONAL VARIANT CustomSubtotal)

PivotTable

Properties

Status

ShowCellBackgroundFromOLAP

Hidden

TableStyle

Hidden

Methods

Status

Format

Hidden

PlotArea

Properties

Status

Border

Hidden

Fill

Hidden

InsideHeight

Changed
Previous syntax
READ-ONLY InsideHeight [DOUBLE]
New syntax
READ-WRITE InsideHeight [DOUBLE]

InsideLeft

Changed
Previous syntax
READ-ONLY InsideLeft [DOUBLE]
New syntax
READ-WRITE InsideLeft [DOUBLE]

InsideTop

Changed
Previous syntax
READ-ONLY InsideTop [DOUBLE]
New syntax
READ-WRITE InsideTop [DOUBLE]

InsideWidth

Changed
Previous syntax
READ-ONLY InsideWidth [DOUBLE]
New syntax
READ-WRITE InsideWidth [DOUBLE]

Interior

Hidden

Point

Properties

Status

Border

Hidden

Fill

Hidden

Interior

Hidden

PictureUnit

Hidden

Range

Properties

Status

FormulaLabel

Hidden

SmartTags

Hidden

Methods

Status

AutoFormat

Hidden

BorderAround

Changed
Previous syntax
VARIANT BorderAround (OPTIONAL VARIANT LineStyle, OPTIONAL XLBORDERWEIGHT Weight = 2, OPTIONAL XLCOLORINDEX ColorIndex = -4105, OPTIONAL VARIANT Color)
New syntax
VARIANT BorderAround (OPTIONAL VARIANT LineStyle, OPTIONAL XLBORDERWEIGHT Weight = 2, OPTIONAL XLCOLORINDEX ColorIndex = -4105, OPTIONAL VARIANT Color, OPTIONAL VARIANT ThemeColor)

CreatePublisher

Hidden

GoalSeek

Hidden

Series

Properties

Status

Border

Hidden

Fill

Hidden

Interior

Hidden

PictureUnit

Hidden

Methods

Status

ApplyCustomType

Hidden

SeriesCollection

Methods

Status

Add

Changed
Previous syntax
SERIES Add (VARIANT Source, OPTIONAL XLROWCOL Rowcol = 2, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace)
New syntax
SERIES Add (VARIANT Source, OPTIONAL XLROWCOL Rowcol = -4105, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace)

Paste

Changed
Previous syntax
VARIANT Paste (OPTIONAL XLROWCOL Rowcol = 2, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace, OPTIONAL VARIANT NewSeries)
New syntax
VARIANT Paste (OPTIONAL XLROWCOL Rowcol = -4105, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace, OPTIONAL VARIANT NewSeries)

Shape

Properties

Status

Diagram

Hidden

DiagramNode

Hidden

HasDiagram

Hidden

HasDiagramNode

Hidden

Script

Hidden

ShapeRange

Properties

Status

Diagram

Hidden

DiagramNode

Hidden

HasDiagram

Hidden

HasDiagramNode

Hidden

Shapes

Methods

Status

AddDiagram

Hidden

Sheets

Methods

Status

PrintOut

Changed
Previous syntax
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)
New syntax
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)

SmartTag

Properties

Status

Application

Hidden

Creator

Hidden

DownloadURL

Hidden

Name

Hidden

Parent

Hidden

Properties

Hidden

Range

Hidden

SmartTagActions

Hidden

XML

Hidden

Methods

Status

Delete

Hidden

SmartTagAction

Properties

Status

ActiveXControl

Hidden

Application

Hidden

CheckboxState

Hidden

Creator

Hidden

ExpandHelp

Hidden

ListSelection

Hidden

Name

Hidden

Parent

Hidden

PresentInPane

Hidden

RadioGroupSelection

Hidden

TextboxText

Hidden

Type

Hidden

Methods

Status

Execute

Hidden

SmartTagActions

Properties

Status

Application

Hidden

Count

Hidden

Creator

Hidden

Item

Hidden

Parent

Hidden

SmartTagOptions

Properties

Status

Application

Hidden

Creator

Hidden

DisplaySmartTags

Hidden

EmbedSmartTags

Hidden

Parent

Hidden

SmartTagRecognizer

Properties

Status

Application

Hidden

Creator

Hidden

Enabled

Hidden

FullName

Hidden

Parent

Hidden

progID

Hidden

SmartTagRecognizers

Properties

Status

Application

Hidden

Count

Hidden

Creator

Hidden

Item

Hidden

Parent

Hidden

Recognize

Hidden

SmartTags

Properties

Status

Application

Hidden

Count

Hidden

Creator

Hidden

Parent

Hidden

Methods

Status

Add

Hidden

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

Routed

Hidden

RoutingSlip

Hidden

SmartTagOptions

Hidden

Methods

Status

CheckIn

Changed
Previous syntax
VOID CheckIn (OPTIONAL VARIANT SaveChanges, OPTIONAL VARIANT Comments, OPTIONAL VARIANT MakePublic)
New syntax
VOID CheckIn (OPTIONAL VARIANT SaveChanges, OPTIONAL VARIANT Comments, OPTIONAL VARIANT MakePublic)

PrintOut

Changed
Previous syntax
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)
New syntax
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
Previous syntax
VOID ProtectSharing (OPTIONAL VARIANT Filename, OPTIONAL VARIANT Password, OPTIONAL VARIANT WriteResPassword, OPTIONAL VARIANT ReadOnlyRecommended, OPTIONAL VARIANT CreateBackup, OPTIONAL VARIANT SharingPassword)
New syntax
VOID ProtectSharing (OPTIONAL VARIANT Filename, OPTIONAL VARIANT Password, OPTIONAL VARIANT WriteResPassword, OPTIONAL VARIANT ReadOnlyRecommended, OPTIONAL VARIANT CreateBackup, OPTIONAL VARIANT SharingPassword, OPTIONAL VARIANT FileFormat)

RecheckSmartTags

Hidden

Route

Hidden

Worksheet

Properties

Status

Scripts

Hidden

SmartTags

Hidden

Methods

Status

PrintOut

Changed
Previous syntax
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)
New syntax
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)

Worksheets

Methods

Status

PrintOut

Changed
Previous syntax
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)
New syntax
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)

Object Model Changes Since Microsoft Office XP (2002)

Application

Properties

Status

AnswerWizard

Hidden

Assistant

Hidden

FileFind

Hidden

FileSearch

Hidden

MemoryFree

Hidden

MemoryTotal

Hidden

MemoryUsed

Hidden

SmartTagRecognizers

Hidden

Methods

Status

AddChartAutoFormat

Hidden

DeleteChartAutoFormat

Hidden

MacroOptions

Changed
Previous syntax
VOID MacroOptions (OPTIONAL VARIANT Macro, OPTIONAL VARIANT Description, OPTIONAL VARIANT HasMenu, OPTIONAL VARIANT MenuText, OPTIONAL VARIANT HasShortcutKey, OPTIONAL VARIANT ShortcutKey, OPTIONAL VARIANT Category, OPTIONAL VARIANT StatusBar, OPTIONAL VARIANT HelpContextID, OPTIONAL VARIANT HelpFile)
New syntax
VOID MacroOptions (OPTIONAL VARIANT Macro, OPTIONAL VARIANT Description, OPTIONAL VARIANT HasMenu, OPTIONAL VARIANT MenuText, OPTIONAL VARIANT HasShortcutKey, OPTIONAL VARIANT ShortcutKey, OPTIONAL VARIANT Category, OPTIONAL VARIANT StatusBar, OPTIONAL VARIANT HelpContextID, OPTIONAL VARIANT HelpFile, OPTIONAL VARIANT ArgumentDescriptions)

SetDefaultChart

Hidden

AxisTitle

Properties

Status

AutoScaleFont

Hidden

Border

Hidden

Fill

Hidden

Font

Hidden

Interior

Hidden

CalculatedMembers

Methods

Status

Add

Changed
Previous syntax
CALCULATEDMEMBER Add (STRING Name, STRING Formula, OPTIONAL VARIANT SolveOrder, OPTIONAL VARIANT Type)
New syntax
CALCULATEDMEMBER Add (STRING Name, VARIANT Formula, OPTIONAL VARIANT SolveOrder, OPTIONAL VARIANT Type, OPTIONAL VARIANT Dynamic, OPTIONAL VARIANT DisplayFolder, OPTIONAL VARIANT HierarchizeDistinct)

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

AreaGroups

Hidden

BarGroups

Hidden

ColumnGroups

Hidden

CreatePublisher

Hidden

Deselect

Hidden

DoughnutGroups

Hidden

LineGroups

Hidden

PieGroups

Hidden

RadarGroups

Hidden

XYGroups

Hidden

Events

Status

DragOver

Hidden

DragPlot

Hidden

ChartArea

Properties

Status

AutoScaleFont

Hidden

Border

Hidden

Fill

Hidden

Font

Hidden

Interior

Hidden

ChartColorFormat

Properties

Status

Application

Hidden

Creator

Hidden

Parent

Hidden

RGB

Hidden

SchemeColor

Hidden

Type

Hidden

ChartFillFormat

Properties

Status

Application

Hidden

BackColor

Hidden

Creator

Hidden

ForeColor

Hidden

GradientColorType

Hidden

GradientDegree

Hidden

GradientStyle

Hidden

GradientVariant

Hidden

Parent

Hidden

Pattern

Hidden

PresetGradientType

Hidden

PresetTexture

Hidden

TextureName

Hidden

TextureType

Hidden

Type

Hidden

Visible

Hidden

Methods

Status

OneColorGradient

Hidden

Patterned

Hidden

PresetGradient

Hidden

PresetTextured

Hidden

Solid

Hidden

TwoColorGradient

Hidden

UserPicture

Hidden

UserTextured

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

Properties

Status

Application

Hidden

Creator

Hidden

Name

Hidden

Parent

Hidden

Methods

Status

Select

Hidden

CubeField

Properties

Status

Caption

Changed
Previous syntax
READ-ONLY Caption [STRING]
New syntax
READ-WRITE Caption [STRING]

HiddenLevels

Hidden

Methods

Status

AddMemberPropertyField

Changed
Previous syntax
VOID AddMemberPropertyField (STRING Property, OPTIONAL VARIANT PropertyOrder)
New syntax
VOID AddMemberPropertyField (STRING Property, OPTIONAL VARIANT PropertyOrder, OPTIONAL VARIANT PropertyDisplayedIn)

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

Diagram

Properties

Status

Application

Hidden

AutoFormat

Hidden

AutoLayout

Hidden

Creator

Hidden

Nodes

Hidden

Parent

Hidden

Reverse

Hidden

Type

Hidden

Methods

Status

Convert

Hidden

DiagramNode

Properties

Status

Application

Hidden

Children

Hidden

Creator

Hidden

Diagram

Hidden

Layout

Hidden

Parent

Hidden

Root

Hidden

Shape

Hidden

TextShape

Hidden

Methods

Status

AddNode

Hidden

CloneNode

Hidden

Delete

Hidden

MoveNode

Hidden

NextNode

Hidden

PrevNode

Hidden

ReplaceNode

Hidden

SwapNode

Hidden

TransferChildren

Hidden

DiagramNodeChildren

Properties

Status

Application

Hidden

Count

Hidden

Creator

Hidden

FirstChild

Hidden

LastChild

Hidden

Parent

Hidden

Methods

Status

AddNode

Hidden

Item

Hidden

SelectAll

Hidden

DiagramNodes

Properties

Status

Application

Hidden

Count

Hidden

Creator

Hidden

Parent

Hidden

Methods

Status

Item

Hidden

SelectAll

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
Previous syntax
READ-ONLY Operator [XLAUTOFILTEROPERATOR]
New syntax
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
Previous syntax
VOID Modify (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2)
New syntax
VOID Modify (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2, OPTIONAL VARIANT String, OPTIONAL VARIANT Operator2)

FormatConditions

Methods

Status

Add

Changed
Previous syntax
FORMATCONDITION Add (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2)
New syntax
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
Previous syntax
FORMATCONDITION Item (VARIANT Index)
New syntax
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

PageSetup

Properties

Status

ChartSize

Hidden

PivotCaches

Methods

Status

Add

Hidden

PivotField

Methods

Status

AutoSort

Changed
Previous syntax
VOID AutoSort (INT32 Order, STRING Field)
New syntax
VOID AutoSort (INT32 Order, STRING Field, OPTIONAL VARIANT PivotLine, OPTIONAL VARIANT CustomSubtotal)

PivotTable

Properties

Status

ShowCellBackgroundFromOLAP

Hidden

TableStyle

Hidden

Methods

Status

Format

Hidden

PlotArea

Properties

Status

Border

Hidden

Fill

Hidden

InsideHeight

Changed
Previous syntax
READ-ONLY InsideHeight [DOUBLE]
New syntax
READ-WRITE InsideHeight [DOUBLE]

InsideLeft

Changed
Previous syntax
READ-ONLY InsideLeft [DOUBLE]
New syntax
READ-WRITE InsideLeft [DOUBLE]

InsideTop

Changed
Previous syntax
READ-ONLY InsideTop [DOUBLE]
New syntax
READ-WRITE InsideTop [DOUBLE]

InsideWidth

Changed
Previous syntax
READ-ONLY InsideWidth [DOUBLE]
New syntax
READ-WRITE InsideWidth [DOUBLE]

Interior

Hidden

Point

Properties

Status

Border

Hidden

Fill

Hidden

Interior

Hidden

PictureUnit

Hidden

Range

Properties

Status

FormulaLabel

Hidden

SmartTags

Hidden

Methods

Status

AutoFormat

Hidden

BorderAround

Changed
Previous syntax
VARIANT BorderAround (OPTIONAL VARIANT LineStyle, OPTIONAL XLBORDERWEIGHT Weight = 2, OPTIONAL XLCOLORINDEX ColorIndex = -4105, OPTIONAL VARIANT Color)
New syntax
VARIANT BorderAround (OPTIONAL VARIANT LineStyle, OPTIONAL XLBORDERWEIGHT Weight = 2, OPTIONAL XLCOLORINDEX ColorIndex = -4105, OPTIONAL VARIANT Color, OPTIONAL VARIANT ThemeColor)

CreatePublisher

Hidden

GoalSeek

Hidden

Series

Properties

Status

Border

Hidden

Fill

Hidden

Interior

Hidden

PictureUnit

Hidden

Methods

Status

ApplyCustomType

Hidden

SeriesCollection

Methods

Status

Add

Changed
Previous syntax
SERIES Add (VARIANT Source, OPTIONAL XLROWCOL Rowcol = 2, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace)
New syntax
SERIES Add (VARIANT Source, OPTIONAL XLROWCOL Rowcol = -4105, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace)

Paste

Changed
Previous syntax
VARIANT Paste (OPTIONAL XLROWCOL Rowcol = 2, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace, OPTIONAL VARIANT NewSeries)
New syntax
VARIANT Paste (OPTIONAL XLROWCOL Rowcol = -4105, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace, OPTIONAL VARIANT NewSeries)

Shape

Properties

Status

Diagram

Hidden

DiagramNode

Hidden

HasDiagram

Hidden

HasDiagramNode

Hidden

Script

Hidden

ShapeRange

Properties

Status

Diagram

Hidden

DiagramNode

Hidden

HasDiagram

Hidden

HasDiagramNode

Hidden

Shapes

Methods

Status

AddDiagram

Hidden

Sheets

Methods

Status

PrintOut

Changed
Previous syntax
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)
New syntax
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)

SmartTag

Properties

Status

Application

Hidden

Creator

Hidden

DownloadURL

Hidden

Name

Hidden

Parent

Hidden

Properties

Hidden

Range

Hidden

SmartTagActions

Hidden

XML

Hidden

Methods

Status

Delete

Hidden

SmartTagAction

Properties

Status

Application

Hidden

Creator

Hidden

Name

Hidden

Parent

Hidden

Methods

Status

Execute

Hidden

SmartTagActions

Properties

Status

Application

Hidden

Count

Hidden

Creator

Hidden

Item

Hidden

Parent

Hidden

SmartTagOptions

Properties

Status

Application

Hidden

Creator

Hidden

DisplaySmartTags

Hidden

EmbedSmartTags

Hidden

Parent

Hidden

SmartTagRecognizer

Properties

Status

Application

Hidden

Creator

Hidden

Enabled

Hidden

FullName

Hidden

Parent

Hidden

progID

Hidden

SmartTagRecognizers

Properties

Status

Application

Hidden

Count

Hidden

Creator

Hidden

Item

Hidden

Parent

Hidden

Recognize

Hidden

SmartTags

Properties

Status

Application

Hidden

Count

Hidden

Creator

Hidden

Parent

Hidden

Methods

Status

Add

Hidden

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

Routed

Hidden

RoutingSlip

Hidden

SmartTagOptions

Hidden

Methods

Status

CheckIn

Changed
Previous syntax
VOID CheckIn (OPTIONAL VARIANT SaveChanges, OPTIONAL VARIANT Comments, OPTIONAL VARIANT MakePublic)
New syntax
VOID CheckIn (OPTIONAL VARIANT SaveChanges, OPTIONAL VARIANT Comments, OPTIONAL VARIANT MakePublic)

PrintOut

Changed
Previous syntax
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)
New syntax
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
Previous syntax
VOID ProtectSharing (OPTIONAL VARIANT Filename, OPTIONAL VARIANT Password, OPTIONAL VARIANT WriteResPassword, OPTIONAL VARIANT ReadOnlyRecommended, OPTIONAL VARIANT CreateBackup, OPTIONAL VARIANT SharingPassword)
New syntax
VOID ProtectSharing (OPTIONAL VARIANT Filename, OPTIONAL VARIANT Password, OPTIONAL VARIANT WriteResPassword, OPTIONAL VARIANT ReadOnlyRecommended, OPTIONAL VARIANT CreateBackup, OPTIONAL VARIANT SharingPassword, OPTIONAL VARIANT FileFormat)

RecheckSmartTags

Hidden

Route

Hidden

Workbooks

Methods

Status

OpenXML

Changed
Previous syntax
WORKBOOK OpenXML (STRING Filename, OPTIONAL VARIANT Stylesheets)
New syntax
WORKBOOK OpenXML (STRING Filename, OPTIONAL VARIANT Stylesheets, OPTIONAL VARIANT LoadOption)

Worksheet

Properties

Status

Scripts

Hidden

SmartTags

Hidden

Methods

Status

PrintOut

Changed
Previous syntax
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)
New syntax
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)

Worksheets

Methods

Status

PrintOut

Changed
Previous syntax
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)
New syntax
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)

Object Model Changes Since Microsoft Office 2000

Application

Properties

Status

AnswerWizard

Hidden

Assistant

Hidden

FileFind

Hidden

FileSearch

Hidden

MemoryFree

Hidden

MemoryTotal

Hidden

MemoryUsed

Hidden

Methods

Status

AddChartAutoFormat

Hidden

DeleteChartAutoFormat

Hidden

MacroOptions

Changed
Previous syntax
VOID MacroOptions (OPTIONAL VARIANT Macro, OPTIONAL VARIANT Description, OPTIONAL VARIANT HasMenu, OPTIONAL VARIANT MenuText, OPTIONAL VARIANT HasShortcutKey, OPTIONAL VARIANT ShortcutKey, OPTIONAL VARIANT Category, OPTIONAL VARIANT StatusBar, OPTIONAL VARIANT HelpContextID, OPTIONAL VARIANT HelpFile)
New syntax
VOID MacroOptions (OPTIONAL VARIANT Macro, OPTIONAL VARIANT Description, OPTIONAL VARIANT HasMenu, OPTIONAL VARIANT MenuText, OPTIONAL VARIANT HasShortcutKey, OPTIONAL VARIANT ShortcutKey, OPTIONAL VARIANT Category, OPTIONAL VARIANT StatusBar, OPTIONAL VARIANT HelpContextID, OPTIONAL VARIANT HelpFile, OPTIONAL VARIANT ArgumentDescriptions)

SetDefaultChart

Hidden

AxisTitle

Properties

Status

AutoScaleFont

Hidden

Border

Hidden

Fill

Hidden

Font

Hidden

Interior

Hidden

CalculatedFields

Methods

Status

Add

Changed
Previous syntax
PIVOTFIELD Add (STRING Name, STRING Formula)
New syntax
PIVOTFIELD Add (STRING Name, STRING Formula, OPTIONAL VARIANT UseStandardFormula)

CalculatedItems

Methods

Status

Add

Changed
Previous syntax
PIVOTITEM Add (STRING Name, STRING Formula)
New syntax
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
Previous syntax
VOID ApplyDataLabels (OPTIONAL XLDATALABELSTYPE Type = 2, OPTIONAL VARIANT LegendKey, OPTIONAL VARIANT AutoText, OPTIONAL VARIANT HasLeaderLines)
New syntax
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
Previous syntax
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)
New syntax
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

Properties

Status

Application

Hidden

Creator

Hidden

Parent

Hidden

RGB

Hidden

SchemeColor

Hidden

Type

Hidden

ChartFillFormat

Properties

Status

Application

Hidden

BackColor

Hidden

Creator

Hidden

ForeColor

Hidden

GradientColorType

Hidden

GradientDegree

Hidden

GradientStyle

Hidden

GradientVariant

Hidden

Parent

Hidden

Pattern

Hidden

PresetGradientType

Hidden

PresetTexture

Hidden

TextureName

Hidden

TextureType

Hidden

Type

Hidden

Visible

Hidden

Methods

Status

OneColorGradient

Hidden

Patterned

Hidden

PresetGradient

Hidden

PresetTextured

Hidden

Solid

Hidden

TwoColorGradient

Hidden

UserPicture

Hidden

UserTextured

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

Properties

Status

Application

Hidden

Creator

Hidden

Name

Hidden

Parent

Hidden

Methods

Status

Select

Hidden

CubeField

Properties

Status

Caption

Changed
Previous syntax
READ-ONLY Caption [STRING]
New syntax
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
Previous syntax
READ-ONLY Operator [XLAUTOFILTEROPERATOR]
New syntax
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
Previous syntax
VOID Modify (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2)
New syntax
VOID Modify (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2, OPTIONAL VARIANT String, OPTIONAL VARIANT Operator2)

FormatConditions

Methods

Status

Add

Changed
Previous syntax
FORMATCONDITION Add (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2)
New syntax
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
Previous syntax
FORMATCONDITION Item (VARIANT Index)
New syntax
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
Previous syntax
PIVOTTABLE CreatePivotTable (VARIANT TableDestination, OPTIONAL VARIANT TableName, OPTIONAL VARIANT ReadData)
New syntax
PIVOTTABLE CreatePivotTable (VARIANT TableDestination, OPTIONAL VARIANT TableName, OPTIONAL VARIANT ReadData, OPTIONAL VARIANT DefaultVersion)

PivotCaches

Methods

Status

Add

Hidden

PivotField

Methods

Status

AutoSort

Changed
Previous syntax
VOID AutoSort (INT32 Order, STRING Field)
New syntax
VOID AutoSort (INT32 Order, STRING Field, OPTIONAL VARIANT PivotLine, OPTIONAL VARIANT CustomSubtotal)

PivotFormulas

Methods

Status

Add

Changed
Previous syntax
PIVOTFORMULA Add (STRING Formula)
New syntax
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

TableStyle

Hidden

Methods

Status

Format

Hidden

PivotSelect

Changed
Previous syntax
VOID PivotSelect (STRING Name, OPTIONAL XLPTSELECTIONMODE Mode = 0)
New syntax
VOID PivotSelect (STRING Name, OPTIONAL XLPTSELECTIONMODE Mode = 0, OPTIONAL VARIANT UseStandardName)

PivotTables

Methods

Status

Add

Changed
Previous syntax
PIVOTTABLE Add (PIVOTCACHE PivotCache, VARIANT TableDestination, OPTIONAL VARIANT TableName, OPTIONAL VARIANT ReadData)
New syntax
PIVOTTABLE Add (PIVOTCACHE PivotCache, VARIANT TableDestination, OPTIONAL VARIANT TableName, OPTIONAL VARIANT ReadData, OPTIONAL VARIANT DefaultVersion)

PlotArea

Properties

Status

Border

Hidden

Fill

Hidden

InsideHeight

Changed
Previous syntax
READ-ONLY InsideHeight [DOUBLE]
New syntax
READ-WRITE InsideHeight [DOUBLE]

InsideLeft

Changed
Previous syntax
READ-ONLY InsideLeft [DOUBLE]
New syntax
READ-WRITE InsideLeft [DOUBLE]

InsideTop

Changed
Previous syntax
READ-ONLY InsideTop [DOUBLE]
New syntax
READ-WRITE InsideTop [DOUBLE]

InsideWidth

Changed
Previous syntax
READ-ONLY InsideWidth [DOUBLE]
New syntax
READ-WRITE InsideWidth [DOUBLE]

Interior

Hidden

Point

Properties

Status

Border

Hidden

Fill

Hidden

Interior

Hidden

PictureUnit

Hidden

Methods

Status

ApplyDataLabels

Changed
Previous syntax
VARIANT ApplyDataLabels (OPTIONAL XLDATALABELSTYPE Type = 2, OPTIONAL VARIANT LegendKey, OPTIONAL VARIANT AutoText)
New syntax
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
Previous syntax
READ-WRITE TextFilePlatform [XLPLATFORM]
New syntax
READ-WRITE TextFilePlatform [INT32]

Range

Properties

Status

FormulaLabel

Hidden

Value

Changed
Previous syntax
READ-WRITE Value [VARIANT]
New syntax
READ-WRITE Value [VARIANT] (OPTIONAL VARIANT RangeValueDataType)

Methods

Status

AutoFormat

Hidden

BorderAround

Changed
Previous syntax
VARIANT BorderAround (OPTIONAL VARIANT LineStyle, OPTIONAL XLBORDERWEIGHT Weight = 2, OPTIONAL XLCOLORINDEX ColorIndex = -4105, OPTIONAL VARIANT Color)
New syntax
VARIANT BorderAround (OPTIONAL VARIANT LineStyle, OPTIONAL XLBORDERWEIGHT Weight = 2, OPTIONAL XLCOLORINDEX ColorIndex = -4105, OPTIONAL VARIANT Color, OPTIONAL VARIANT ThemeColor)

CreatePublisher

Hidden

Find

Changed
Previous syntax
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)
New syntax
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
Previous syntax
VARIANT Insert (OPTIONAL VARIANT Shift)
New syntax
VARIANT Insert (OPTIONAL VARIANT Shift, OPTIONAL VARIANT CopyOrigin)

Replace

Changed
Previous syntax
BOOL Replace (VARIANT What, VARIANT Replacement, OPTIONAL VARIANT LookAt, OPTIONAL VARIANT SearchOrder, OPTIONAL VARIANT MatchCase, OPTIONAL VARIANT MatchByte)
New syntax
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
Previous syntax
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)
New syntax
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
Previous syntax
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)
New syntax
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
Previous syntax
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)
New syntax
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
Previous syntax
VARIANT ApplyDataLabels (OPTIONAL XLDATALABELSTYPE Type = 2, OPTIONAL VARIANT LegendKey, OPTIONAL VARIANT AutoText, OPTIONAL VARIANT HasLeaderLines)
New syntax
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)

SeriesCollection

Methods

Status

Add

Changed
Previous syntax
SERIES Add (VARIANT Source, OPTIONAL XLROWCOL Rowcol = 2, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace)
New syntax
SERIES Add (VARIANT Source, OPTIONAL XLROWCOL Rowcol = -4105, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace)

Paste

Changed
Previous syntax
VARIANT Paste (OPTIONAL XLROWCOL Rowcol = 2, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace, OPTIONAL VARIANT NewSeries)
New syntax
VARIANT Paste (OPTIONAL XLROWCOL Rowcol = -4105, OPTIONAL VARIANT SeriesLabels, OPTIONAL VARIANT CategoryLabels, OPTIONAL VARIANT Replace, OPTIONAL VARIANT NewSeries)

Shape

Properties

Status

Script

Hidden

Sheets

Methods

Status

PrintOut

Changed
Previous syntax
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)
New syntax
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
Previous syntax
READ-ONLY ReadOnlyRecommended [BOOL]
New syntax
READ-WRITE ReadOnlyRecommended [BOOL]

Routed

Hidden

RoutingSlip

Hidden

Methods

Status

PrintOut

Changed
Previous syntax
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)
New syntax
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
Previous syntax
VOID ProtectSharing (OPTIONAL VARIANT Filename, OPTIONAL VARIANT Password, OPTIONAL VARIANT WriteResPassword, OPTIONAL VARIANT ReadOnlyRecommended, OPTIONAL VARIANT CreateBackup, OPTIONAL VARIANT SharingPassword)
New syntax
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
Previous syntax
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)
New syntax
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
Previous syntax
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)
New syntax
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
Previous syntax
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)
New syntax
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
Previous syntax
VOID PasteSpecial (OPTIONAL VARIANT Format, OPTIONAL VARIANT Link, OPTIONAL VARIANT DisplayAsIcon, OPTIONAL VARIANT IconFileName, OPTIONAL VARIANT IconIndex, OPTIONAL VARIANT IconLabel)
New syntax
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
Previous syntax
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)
New syntax
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
Previous syntax
VOID Protect (OPTIONAL VARIANT Password, OPTIONAL VARIANT DrawingObjects, OPTIONAL VARIANT Contents, OPTIONAL VARIANT Scenarios, OPTIONAL VARIANT UserInterfaceOnly)
New syntax
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
Previous syntax
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)
New syntax
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
Previous syntax
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)
New syntax
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)