Microsoft Office Tutorials and References
In Depth Information
Appendix G. New Objects in Excel XP
The AutoRecover object implements automatic recovery. Its Path property sets the location where
Excel will place the AutoRecover file and its Time property sets the time (in minutes) interval for
backing up the workbook to the AutoRecover file, as in:
Application.AutoRecover.Path = "d:\temp"
Application.AutoRecover.Time = 10' minutes
CalculatedMember Object
Path: Application -- Range -- PivotTable --
CalculatedMembers - CalculatedMember
Object
Methods
Properties
Formula() As String
IsValid() As Boolean
Name() As String
SolveOrder() As Long
SourceName() As String
Type() As
XlCalculatedMemberType
Delete()
CalculatedMember
Add(Name As String
Formula As String
[SolveOrder] As Variant
[Type] As Variant) As
CalculatedMember
Count() As Long
Item(Index As Variant) As
CalculatedMember
CalculatedMembers
The CalculatedMember object programmatically manipulates the calculated fields and calculated
items for PivotTables that are connected to external OLAP (Online Analytical Processing) data
sources. We will not discuss these data sources further in this topic.
CellFormat Object
Path: Application - CellFormat
Object
Methods
Properties
AddIndent() As Variant
Borders() As Borders
Font() As Font
FormulaHidden() As Variant
HorizontalAlignment() As Variant
IndentLevel() As Variant
Interior() As Interior
Locked() As Variant
MergeCells() As Variant
NumberFormat() As Variant
NumberFormatLocal() As Variant
Clear()
CellFormat
 
 
 
 
 
 
Search JabSto ::




Custom Search