Programming Excel with VBA and .NET

Appendix B. Version Compatibility

See Chapter 6 for instructions on how to check the Excel version at runtime and recommendations on how to handle version differences. Table B-1 lists the Excel objects by year introduced. The sections that follow the table summarize the changes for each version. In this table, X=available, H=hidden or obsolete, and M=Macintosh only.

Table B-1. Excel objects listed by product version

	Excel year (version)
Object	1995 (7)	1997 (8)	2000 (9)	2002 (10)	2003 (11)
AddIn	X	X	X	X	X
Adjustments		X	X	X	X
AllowEditRange				X	X
Application	X	X	X	X	X
Arc	X	H	H	H	H
Areas	X	X	X	X	X
AutoCorrect	X	X	X	X	X
AutoFilter	X	X	X	X	X
AutoRecover				X	X
Axis	X	X	X	X	X
AxisTitle	X	X	X	X	X
Border	X	X	X	X	X
Button	X	H	H	H	H
CalculatedFields		X	X	X	X
CalculatedItems		X	X	X	X
CalculatedMember				X	X
CalloutFormat		X	X	X	X
CellFormat				X	X
Characters	X	X	X	X	X
Chart	X	X	X	X	X
ChartArea	X	X	X	X	X
ChartColorFormat		X	X	X	X
ChartFillFormat		X	X	X	X
ChartGroup	X	X	X	X	X
ChartObject	X	X	X	X	X
ChartTitle	X	X	X	X	X
CheckBox	X	H	H	H	H
ColorFormat		X	X	X	X
Comment		X	X	X	X
ConnectorFormat	X	X	X	X	X
ControlFormat		X	X	X	X
Corners	X	X	X	X	X
CubeField			X	X	X
CustomProperty				X	X
CustomView		X	X	X	X
DataLabel	X	X	X	X	X
DataTable		X	X	X	X
DefaultWebOptions			X	X	X
Diagram				X	X
DiagramNode ...