Object Model Changes Since Microsoft Office XP (2002)
| Excel Developer Reference |
The following is a summary of the changes in the Microsoft Office Excel 2007 object model as compared to Microsoft Office XP (2002).
| Properties | Status |
|---|---|
| FileFind | Hidden |
| FileSearch | Hidden |
| MemoryFree | Hidden |
| MemoryTotal | Hidden |
| MemoryUsed | Hidden |
| Methods | Status |
|---|---|
| AddChartAutoFormat | Hidden |
| DeleteChartAutoFormat | Hidden |
| SetDefaultChart | Hidden |
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
| Border | Hidden |
| Fill | Hidden |
| Font | Hidden |
| Interior | Hidden |
| 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 |
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
| Border | Hidden |
| Fill | Hidden |
| Font | Hidden |
| Interior | Hidden |
Hidden
Hidden
| Properties | Status |
|---|---|
| Border | Hidden |
| Enabled | Hidden |
| Interior | Hidden |
| Properties | Status |
|---|---|
| Border | Hidden |
| Enabled | Hidden |
| Interior | Hidden |
| RoundedCorners | Hidden |
| Shadow | Hidden |
| Methods | Status |
|---|---|
| BringToFront | Hidden |
| SendToBack | Hidden |
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
| Border | Hidden |
| Fill | Hidden |
| Font | Hidden |
| Interior | Hidden |
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)
|
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
| Border | Hidden |
| Fill | Hidden |
| Font | Hidden |
| Interior | Hidden |
| Type | Hidden |
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
| Border | Hidden |
| Fill | Hidden |
| Font | Hidden |
| Interior | Hidden |
| Type | Hidden |
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
Hidden
Hidden
Hidden
Hidden
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
| Border | Hidden |
| Fill | Hidden |
| Font | Hidden |
| Interior | Hidden |
| Properties | Status |
|---|---|
| Border | Hidden |
| Fill | Hidden |
| Interior | Hidden |
| Properties | Status |
|---|---|
| Operator | Changed
READ-ONLY Operator [XLAUTOFILTEROPERATOR]
READ-WRITE Operator [XLAUTOFILTEROPERATOR]
|
| Properties | Status |
|---|---|
| Border | Hidden |
| Fill | Hidden |
| Interior | Hidden |
| Properties | Status |
|---|---|
| OutlineFont | Hidden |
| Shadow | Hidden |
| Methods | Status |
|---|---|
| Modify | Changed
VOID Modify (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2)
VOID Modify (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2, OPTIONAL VARIANT String, OPTIONAL VARIANT Operator2)
|
| Methods | Status |
|---|---|
| Add | Changed
FORMATCONDITION Add (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2)
OBJECT Add (XLFORMATCONDITIONTYPE Type, OPTIONAL VARIANT Operator, OPTIONAL VARIANT Formula1, OPTIONAL VARIANT Formula2, OPTIONAL VARIANT String, OPTIONAL VARIANT TextOperator, OPTIONAL VARIANT DateOperator, OPTIONAL VARIANT ScopeType)
|
| Item | Changed
FORMATCONDITION Item (VARIANT Index)
OBJECT Item (VARIANT Index)
|
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
| Border | Hidden |
| Fill | Hidden |
| Font | Hidden |
| Interior | Hidden |
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
| Properties | Status |
|---|---|
| Border | Hidden |
| Fill | Hidden |
| Interior | Hidden |
| PictureUnit | Hidden |
| Methods | Status |
|---|---|
| Select | Hidden |
| Properties | Status |
|---|---|
| ChartSize | Hidden |
| Methods | Status |
|---|---|
| Add | Hidden |
| Methods | Status |
|---|---|
| AutoSort | Changed
VOID AutoSort (INT32 Order, STRING Field)
VOID AutoSort (INT32 Order, STRING Field, OPTIONAL VARIANT PivotLine, OPTIONAL VARIANT CustomSubtotal)
|
| Properties | Status |
|---|---|
| HasAutoFormat | Hidden |
| ShowCellBackgroundFromOLAP | Hidden |
| TableStyle | Hidden |
| Methods | Status |
|---|---|
| Format | Hidden |
| Properties | Status |
|---|---|
| Border | Hidden |
| Fill | Hidden |
| InsideHeight | Changed
READ-ONLY InsideHeight [DOUBLE]
READ-WRITE InsideHeight [DOUBLE]
|
| InsideLeft | Changed
READ-ONLY InsideLeft [DOUBLE]
READ-WRITE InsideLeft [DOUBLE]
|
| InsideTop | Changed
READ-ONLY InsideTop [DOUBLE]
READ-WRITE InsideTop [DOUBLE]
|
| InsideWidth | Changed
READ-ONLY InsideWidth [DOUBLE]
READ-WRITE InsideWidth [DOUBLE]
|
| Interior | Hidden |
| Properties | Status |
|---|---|
| Border | Hidden |
| Fill | Hidden |
| Interior | Hidden |
| PictureUnit | Hidden |
| Properties | Status |
|---|---|
| FormulaLabel | Hidden |
| Methods | Status |
|---|---|
| AutoFormat | Hidden |
| CreatePublisher | Hidden |
| GoalSeek | Hidden |
| Properties | Status |
|---|---|
| Border | Hidden |
| Fill | Hidden |
| Interior | Hidden |
| PictureUnit | Hidden |
| Methods | Status |
|---|---|
| ApplyCustomType | Hidden |
| Properties | Status |
|---|---|
| Diagram | Hidden |
| DiagramNode | Hidden |
| HasDiagram | Hidden |
| HasDiagramNode | Hidden |
| Script | Hidden |
| Properties | Status |
|---|---|
| Diagram | Hidden |
| DiagramNode | Hidden |
| HasDiagram | Hidden |
| HasDiagramNode | Hidden |
| Methods | Status |
|---|---|
| AddDiagram | 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)
|
| Properties | Status |
|---|---|
| AutoScaleFont | Hidden |
| Properties | Status |
|---|---|
| Backward | Hidden |
| Forward | Hidden |
| Properties | Status |
|---|---|
| Border | Hidden |
| Fill | Hidden |
| Interior | Hidden |
| Properties | Status |
|---|---|
| Border | Hidden |
| Fill | Hidden |
| Interior | Hidden |
| Properties | Status |
|---|---|
| AcceptLabelsInFormulas | Hidden |
| HasRoutingSlip | Hidden |
| HTMLProject | Hidden |
| 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 |
| Methods | Status |
|---|---|
| OpenXML | Changed
WORKBOOK OpenXML (STRING Filename, OPTIONAL VARIANT Stylesheets)
WORKBOOK OpenXML (STRING Filename, OPTIONAL VARIANT Stylesheets, OPTIONAL VARIANT LoadOption)
|
| Properties | Status |
|---|---|
| Scripts | 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)
|
| 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)
|