2 out of 12 rated this helpful - Rate this topic

Object Model Changes Since Microsoft Office 2003

Office 2007

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

Application

Properties	Status
FileFind	Hidden
FileSearch	Hidden

Methods	Status
AddChartAutoFormat	Hidden
DeleteChartAutoFormat	Hidden
SetDefaultChart	Hidden

AxisTitle

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

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

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

Properties

Status

Caption

Changed

READ-ONLY Caption [STRING]

READ-WRITE Caption [STRING]

HiddenLevels

Hidden

Methods	Status
AddMemberPropertyField	Changed VOID AddMemberPropertyField (STRING Property, OPTIONAL VARIANT PropertyOrder) VOID AddMemberPropertyField (STRING Property, OPTIONAL VARIANT PropertyOrder, OPTIONAL VARIANT PropertyDisplayedIn)

Methods

Status

AddMemberPropertyField

Changed

VOID AddMemberPropertyField (STRING Property, OPTIONAL VARIANT PropertyOrder)

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

Hidden

DiagramNode

Hidden

DiagramNodeChildren

Hidden

DiagramNodes

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]

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)

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)

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

ListColumn

Properties	Status
ListDataFormat	Hidden
SharePointFormula	Hidden

ListObject

Methods	Status
UpdateChanges	Hidden

ListObjects

Methods	Status
Add	Changed LISTOBJECT Add (OPTIONAL XLLISTOBJECTSOURCETYPE SourceType = 1, OPTIONAL VARIANT Source, OPTIONAL VARIANT LinkSource, OPTIONAL XLYESNOGUESS XlListObjectHasHeaders = 0, OPTIONAL VARIANT Destination) LISTOBJECT Add (OPTIONAL XLLISTOBJECTSOURCETYPE SourceType = 1, OPTIONAL VARIANT Source, OPTIONAL VARIANT LinkSource, OPTIONAL XLYESNOGUESS XlListObjectHasHeaders = 0, OPTIONAL VARIANT Destination, OPTIONAL VARIANT TableStyleName)

Methods

Status

Add

Changed

LISTOBJECT Add (OPTIONAL XLLISTOBJECTSOURCETYPE SourceType = 1, OPTIONAL VARIANT Source, OPTIONAL VARIANT LinkSource, OPTIONAL XLYESNOGUESS XlListObjectHasHeaders = 0, OPTIONAL VARIANT Destination)

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 LISTROW Add (OPTIONAL VARIANT Position) LISTROW Add (OPTIONAL VARIANT Position, OPTIONAL VARIANT AlwaysInsert)

Methods

Status

Add

Changed

LISTROW Add (OPTIONAL VARIANT Position)

LISTROW Add (OPTIONAL VARIANT Position, OPTIONAL VARIANT AlwaysInsert)

PageSetup

Properties	Status
ChartSize	Hidden

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)

Methods

Status

AutoSort

Changed

VOID AutoSort (INT32 Order, STRING Field)

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

PivotTable

Properties	Status
HasAutoFormat	Hidden
ShowCellBackgroundFromOLAP	Hidden
TableStyle	Hidden

Methods	Status
Format	Hidden

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

Range

Properties	Status
FormulaLabel	Hidden

Methods	Status
AutoFormat	Hidden
CreatePublisher	Hidden
GoalSeek	Hidden

Series

Properties	Status
Border	Hidden
Fill	Hidden
Interior	Hidden
PictureUnit	Hidden

Methods	Status
ApplyCustomType	Hidden

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

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)

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

Methods	Status
CheckIn	Changed VOID CheckIn (OPTIONAL VARIANT SaveChanges, OPTIONAL VARIANT Comments, OPTIONAL VARIANT MakePublic) VOID CheckIn (OPTIONAL VARIANT SaveChanges, OPTIONAL VARIANT Comments, OPTIONAL VARIANT MakePublic, OPTIONAL VARIANT VersionType)
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

Worksheet

Properties	Status
Scripts	Hidden

Methods

Status

PrintOut

Changed

Worksheets

Methods

Status

PrintOut

Changed

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ

Why are members hidden?

Why has Microsoft hidden many of the member functions? Is this a prelude to them going away? I rely heavily on the UpdateChanges method but it was hidden. I was able to unhide it, but it doesn't work any more. When I run the exact same code within Excel 2003, it works, but in Excel 2007, I get the hated message: Run-time error '1004': Application-defined or Object-defined error." Sounds like Microsoft did more than just hide UpdateChanges. Has anyone else had a similar experience?

History

2/17/2010
SixSigmaGuy

Re: Where did my method go?

FileSearch is not supported in Office 2007 (see http://support.microsoft.com/default.aspx/kb/920229).

Instead, use Windows Desktop Search (see http://msdn.microsoft.com/en-us/library/aa965362.aspx).

History

4/9/2009
Allison Bokone - MSFT

6/28/2009
Thomas Lee

Hidden members

how do i activate the hidden members?

[tfl - 28 06 09] Hi - and thanks for your post. You should post questions like this to the MSDN Forums at http://forums.microsoft.com/msdn or the MSDN Newsgroups at

http://www.microsoft.com/communities/newsgroups/en-us/. You are much more likely get a quicker response using the forums than through the Community Content. For specific help about:
Visual Studio  : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.vstudio%2C&
SQL Server     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&
.NET Framework : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.dotnet.framework
All Public     : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&

History

6/26/2009
rickiii

6/28/2009
Thomas Lee

RE: Where did my method go?

OK, so I can "show hidden members" now. I'm trying to use application.filesearch in Excel 2007. It still doesn't work. Does anybody know how to get this to work in 2007? Or is there a replacement for this?

History