(0) exportieren Drucken
Alle erweitern
_Application Interface
_Chart Interface
_Global Interface
_IOLEObject Interface
_IQueryTable Interface
_OLEObject Interface
_QueryTable Interface
_Workbook Interface
_Worksheet Interface
AddIn Interface
AddIns Interface
Adjustments Interface
AllowEditRange Interface
AllowEditRanges Interface
AppEvents Interface
AppEvents_Event Interface
AppEvents_NewWorkbookEventHandler Delegate
AppEvents_SheetActivateEventHandler Delegate
AppEvents_SheetBeforeDoubleClickEventHandler Delegate
AppEvents_SheetBeforeRightClickEventHandler Delegate
AppEvents_SheetCalculateEventHandler Delegate
AppEvents_SheetChangeEventHandler Delegate
AppEvents_SheetDeactivateEventHandler Delegate
AppEvents_SheetFollowHyperlinkEventHandler Delegate
AppEvents_SheetPivotTableUpdateEventHandler Delegate
AppEvents_SheetSelectionChangeEventHandler Delegate
AppEvents_SinkHelper Class
AppEvents_WindowActivateEventHandler Delegate
AppEvents_WindowDeactivateEventHandler Delegate
AppEvents_WindowResizeEventHandler Delegate
AppEvents_WorkbookActivateEventHandler Delegate
AppEvents_WorkbookAddinInstallEventHandler Delegate
AppEvents_WorkbookAddinUninstallEventHandler Delegate
AppEvents_WorkbookAfterXmlExportEventHandler Delegate
AppEvents_WorkbookAfterXmlImportEventHandler Delegate
AppEvents_WorkbookBeforeCloseEventHandler Delegate
AppEvents_WorkbookBeforePrintEventHandler Delegate
AppEvents_WorkbookBeforeSaveEventHandler Delegate
AppEvents_WorkbookBeforeXmlExportEventHandler Delegate
AppEvents_WorkbookBeforeXmlImportEventHandler Delegate
AppEvents_WorkbookDeactivateEventHandler Delegate
AppEvents_WorkbookNewSheetEventHandler Delegate
AppEvents_WorkbookOpenEventHandler Delegate
AppEvents_WorkbookPivotTableCloseConnectionEventHandler Delegate
AppEvents_WorkbookPivotTableOpenConnectionEventHandler Delegate
AppEvents_WorkbookSyncEventHandler Delegate
Application Interface
ApplicationClass Class
Arc Interface
Arcs Interface
Areas Interface
AutoCorrect Interface
AutoFilter Interface
AutoRecover Interface
Axes Interface
Axis Interface
AxisTitle Interface
Border Interface
Borders Interface
Button Interface
Buttons Interface
CalculatedFields Interface
CalculatedItems Interface
CalculatedMember Interface
CalculatedMembers Interface
CalloutFormat Interface
CellFormat Interface
Characters Interface
Chart Interface
ChartArea Interface
ChartClass Class
ChartColorFormat Interface
ChartEvents Interface
ChartEvents_ActivateEventHandler Delegate
ChartEvents_BeforeDoubleClickEventHandler Delegate
ChartEvents_BeforeRightClickEventHandler Delegate
ChartEvents_CalculateEventHandler Delegate
ChartEvents_DeactivateEventHandler Delegate
ChartEvents_DragOverEventHandler Delegate
ChartEvents_DragPlotEventHandler Delegate
ChartEvents_Event Interface
ChartEvents_MouseDownEventHandler Delegate
ChartEvents_MouseMoveEventHandler Delegate
ChartEvents_MouseUpEventHandler Delegate
ChartEvents_ResizeEventHandler Delegate
ChartEvents_SelectEventHandler Delegate
ChartEvents_SeriesChangeEventHandler Delegate
ChartEvents_SinkHelper Class
ChartFillFormat Interface
ChartGroup Interface
ChartGroups Interface
ChartObject Interface
ChartObjects Interface
Charts Interface
ChartTitle Interface
CheckBox Interface
CheckBoxes Interface
ColorFormat Interface
Comment Interface
Comments Interface
ConnectorFormat Interface
Constants Enumeration
ControlFormat Interface
Corners Interface
CubeField Interface
CubeFields Interface
CustomProperties Interface
CustomProperty Interface
CustomView Interface
CustomViews Interface
DataLabel Interface
DataLabels Interface
DataTable Interface
DefaultWebOptions Interface
Diagram Interface
DiagramNode Interface
DiagramNodeChildren Interface
DiagramNodes Interface
Dialog Interface
DialogFrame Interface
Dialogs Interface
DialogSheet Interface
DialogSheets Interface
DisplayUnitLabel Interface
DocEvents Interface
DocEvents_ActivateEventHandler Delegate
DocEvents_BeforeDoubleClickEventHandler Delegate
DocEvents_BeforeRightClickEventHandler Delegate
DocEvents_CalculateEventHandler Delegate
DocEvents_ChangeEventHandler Delegate
DocEvents_DeactivateEventHandler Delegate
DocEvents_Event Interface
DocEvents_FollowHyperlinkEventHandler Delegate
DocEvents_PivotTableUpdateEventHandler Delegate
DocEvents_SelectionChangeEventHandler Delegate
DocEvents_SinkHelper Class
DownBars Interface
Drawing Interface
DrawingObjects Interface
Drawings Interface
DropDown Interface
DropDowns Interface
DropLines Interface
EditBox Interface
EditBoxes Interface
Error Interface
ErrorBars Interface
ErrorCheckingOptions Interface
Errors Interface
FillFormat Interface
Filter Interface
Filters Interface
Floor Interface
Font Interface
FormatCondition Interface
FormatConditions Interface
FreeformBuilder Interface
Global Interface
GlobalClass Class
Graphic Interface
Gridlines Interface
GroupBox Interface
GroupBoxes Interface
GroupObject Interface
GroupObjects Interface
GroupShapes Interface
HiLoLines Interface
HPageBreak Interface
HPageBreaks Interface
Hyperlink Interface
Hyperlinks Interface
IAddIn Interface
IAddIns Interface
IAllowEditRange Interface
IAllowEditRanges Interface
IAppEvents Interface
IArc Interface
IArcs Interface
IAreas Interface
IAutoCorrect Interface
IAutoFilter Interface
IAutoRecover Interface
IAxes Interface
IAxis Interface
IAxisTitle Interface
IBorder Interface
IBorders Interface
IButton Interface
IButtons Interface
ICalculatedFields Interface
ICalculatedItems Interface
ICalculatedMember Interface
ICalculatedMembers Interface
ICanvasShapes Interface
ICellFormat Interface
ICharacters Interface
IChartArea Interface
IChartColorFormat Interface
IChartEvents Interface
IChartFillFormat Interface
IChartGroup Interface
IChartGroups Interface
IChartObject Interface
IChartObjects Interface
ICharts Interface
IChartTitle Interface
ICheckBox Interface
ICheckBoxes Interface
IComment Interface
IComments Interface
IConnectorFormat Interface
IControlFormat Interface
ICorners Interface
ICustomProperties Interface
ICustomProperty Interface
ICustomView Interface
ICustomViews Interface
IDataLabel Interface
IDataLabels Interface
IDataTable Interface
IDiagram Interface
IDialog Interface
IDialogFrame Interface
IDialogs Interface
IDialogSheet Interface
IDialogSheets Interface
IDisplayUnitLabel Interface
IDocEvents Interface
IDownBars Interface
IDrawing Interface
IDrawingObjects Interface
IDrawings Interface
IDropDown Interface
IDropDowns Interface
IDropLines Interface
IDummy Interface
IEditBox Interface
IEditBoxes Interface
IError Interface
IErrorBars Interface
IErrorCheckingOptions Interface
IErrors Interface
IFilter Interface
IFilters Interface
IFloor Interface
IFont Interface
IFormatCondition Interface
IFormatConditions Interface
IFreeformBuilder Interface
IGraphic Interface
IGridlines Interface
IGroupBox Interface
IGroupBoxes Interface
IGroupObject Interface
IGroupObjects Interface
IGroupShapes Interface
IHiLoLines Interface
IHPageBreak Interface
IHPageBreaks Interface
IHyperlink Interface
IHyperlinks Interface
IInterior Interface
ILabel Interface
ILabels Interface
ILeaderLines Interface
ILegend Interface
ILegendEntries Interface
ILegendEntry Interface
ILegendKey Interface
ILine Interface
ILines Interface
ILinkFormat Interface
IListBox Interface
IListBoxes Interface
IListColumn Interface
IListColumns Interface
IListDataFormat Interface
IListObject Interface
IListObjects Interface
IListRow Interface
IListRows Interface
IMailer Interface
IMenu Interface
IMenuBar Interface
IMenuBars Interface
IMenuItem Interface
IMenuItems Interface
IMenus Interface
IModule Interface
IModules Interface
IName Interface
INames Interface
Interior Interface
IODBCError Interface
IODBCErrors Interface
IOLEDBError Interface
IOLEDBErrors Interface
IOLEFormat Interface
IOLEObjectEvents Interface
IOLEObjects Interface
IOptionButton Interface
IOptionButtons Interface
IOutline Interface
IOval Interface
IOvals Interface
IPageSetup Interface
IPane Interface
IPanes Interface
IParameter Interface
IParameters Interface
IPhonetic Interface
IPhonetics Interface
IPicture Interface
IPictures Interface
IPivotCache Interface
IPivotCaches Interface
IPivotCell Interface
IPivotField Interface
IPivotFields Interface
IPivotFormula Interface
IPivotFormulas Interface
IPivotItem Interface
IPivotItemList Interface
IPivotItems Interface
IPivotLayout Interface
IPivotTable Interface
IPivotTables Interface
IPlotArea Interface
IPoint Interface
IPoints Interface
IProtection Interface
IPublishObjects Interface
IQueryTables Interface
IRange Interface
IRecentFile Interface
IRecentFiles Interface
IRectangle Interface
IRectangles Interface
IRefreshEvents Interface
IRoutingSlip Interface
IRTD Interface
IRtdServer Interface
IRTDUpdateEvent Interface
IScenario Interface
IScenarios Interface
IScrollBar Interface
IScrollBars Interface
ISeries Interface
ISeriesCollection Interface
ISeriesLines Interface
IShape Interface
IShapeRange Interface
IShapes Interface
ISmartTag Interface
ISmartTagAction Interface
ISmartTagActions Interface
ISmartTagOptions Interface
ISmartTagRecognizer Interface
ISmartTagRecognizers Interface
ISmartTags Interface
ISoundNote Interface
ISpeech Interface
ISpellingOptions Interface
ISpinner Interface
ISpinners Interface
IStyle Interface
IStyles Interface
ITab Interface
ITextBox Interface
ITextBoxes Interface
ITextFrame Interface
ITickLabels Interface
IToolbar Interface
IToolbarButton Interface
IToolbarButtons Interface
IToolbars Interface
ITrendline Interface
ITrendlines Interface
IUpBars Interface
IUsedObjects Interface
IUserAccess Interface
IUserAccessList Interface
IValidation Interface
IVPageBreak Interface
IVPageBreaks Interface
IWalls Interface
IWatch Interface
IWatches Interface
IWindow Interface
IWindows Interface
IWorkbookEvents Interface
IWorksheetFunction Interface
IWorksheets Interface
IXmlDataBinding Interface
IXmlMap Interface
IXmlMaps Interface
IXmlNamespace Interface
IXmlNamespaces Interface
IXmlSchema Interface
IXmlSchemas Interface
IXPath Interface
Label Interface
Labels Interface
LeaderLines Interface
Legend Interface
LegendEntries Interface
LegendEntry Interface
LegendKey Interface
Line Interface
LineFormat Interface
Lines Interface
LinkFormat Interface
ListBox Interface
ListBoxes Interface
ListColumn Interface
ListColumns Interface
ListDataFormat Interface
ListObject Interface
ListObjects Interface
ListRow Interface
ListRows Interface
Mailer Interface
Menu Interface
MenuBar Interface
MenuBars Interface
MenuItem Interface
MenuItems Interface
Menus Interface
Module Interface
Modules Interface
Name Interface
Names Interface
ODBCError Interface
ODBCErrors Interface
OLEDBError Interface
OLEDBErrors Interface
OLEFormat Interface
OLEObject Interface
OLEObjectClass Class
OLEObjectEvents Interface
OLEObjectEvents_Event Interface
OLEObjectEvents_GotFocusEventHandler Delegate
OLEObjectEvents_LostFocusEventHandler Delegate
OLEObjectEvents_SinkHelper Class
OLEObjects Interface
OptionButton Interface
OptionButtons Interface
Outline Interface
Oval Interface
Ovals Interface
PageSetup Interface
Pane Interface
Panes Interface
Parameter Interface
Parameters Interface
Phonetic Interface
Phonetics Interface
Picture Interface
PictureFormat Interface
Pictures Interface
PivotCache Interface
PivotCaches Interface
PivotCell Interface
PivotField Interface
PivotFields Interface
PivotFormula Interface
PivotFormulas Interface
PivotItem Interface
PivotItemList Interface
PivotItems Interface
PivotLayout Interface
PivotTable Interface
PivotTables Interface
PlotArea Interface
Point Interface
Points Interface
Protection Interface
PublishObject Interface
PublishObjects Interface
QueryTable Interface
QueryTableClass Class
QueryTables Interface
Range Interface
RecentFile Interface
RecentFiles Interface
Rectangle Interface
Rectangles Interface
RefreshEvents Interface
RefreshEvents_AfterRefreshEventHandler Delegate
RefreshEvents_BeforeRefreshEventHandler Delegate
RefreshEvents_Event Interface
RefreshEvents_SinkHelper Class
RoutingSlip Interface
RTD Interface
Scenario Interface
Scenarios Interface
ScrollBar Interface
ScrollBars Interface
Series Interface
SeriesCollection Interface
SeriesLines Interface
ShadowFormat Interface
Shape Interface
ShapeNode Interface
ShapeNodes Interface
ShapeRange Interface
Shapes Interface
Sheets Interface
SmartTag Interface
SmartTagAction Interface
SmartTagActions Interface
SmartTagOptions Interface
SmartTagRecognizer Interface
SmartTagRecognizers Interface
SmartTags Interface
SoundNote Interface
Speech Interface
SpellingOptions Interface
Spinner Interface
Spinners Interface
Style Interface
Styles Interface
Tab Interface
TextBox Interface
TextBoxes Interface
TextEffectFormat Interface
TextFrame Interface
ThreeDFormat Interface
TickLabels Interface
Toolbar Interface
ToolbarButton Interface
ToolbarButtons Interface
Toolbars Interface
TreeviewControl Interface
Trendline Interface
Trendlines Interface
UpBars Interface
UsedObjects Interface
UserAccess Interface
UserAccessList Interface
Validation Interface
VPageBreak Interface
VPageBreaks Interface
Walls Interface
Watch Interface
Watches Interface
WebOptions Interface
Window Interface
Windows Interface
Workbook Interface
WorkbookClass Class
WorkbookEvents Interface
WorkbookEvents_ActivateEventHandler Delegate
WorkbookEvents_AddinInstallEventHandler Delegate
WorkbookEvents_AddinUninstallEventHandler Delegate
WorkbookEvents_AfterXmlExportEventHandler Delegate
WorkbookEvents_AfterXmlImportEventHandler Delegate
WorkbookEvents_BeforeCloseEventHandler Delegate
WorkbookEvents_BeforePrintEventHandler Delegate
WorkbookEvents_BeforeSaveEventHandler Delegate
WorkbookEvents_BeforeXmlExportEventHandler Delegate
WorkbookEvents_BeforeXmlImportEventHandler Delegate
WorkbookEvents_DeactivateEventHandler Delegate
WorkbookEvents_Event Interface
WorkbookEvents_NewSheetEventHandler Delegate
WorkbookEvents_OpenEventHandler Delegate
WorkbookEvents_PivotTableCloseConnectionEventHandler Delegate
WorkbookEvents_PivotTableOpenConnectionEventHandler Delegate
WorkbookEvents_SheetActivateEventHandler Delegate
WorkbookEvents_SheetBeforeDoubleClickEventHandler Delegate
WorkbookEvents_SheetBeforeRightClickEventHandler Delegate
WorkbookEvents_SheetCalculateEventHandler Delegate
WorkbookEvents_SheetChangeEventHandler Delegate
WorkbookEvents_SheetDeactivateEventHandler Delegate
WorkbookEvents_SheetFollowHyperlinkEventHandler Delegate
WorkbookEvents_SheetPivotTableUpdateEventHandler Delegate
WorkbookEvents_SheetSelectionChangeEventHandler Delegate
WorkbookEvents_SinkHelper Class
WorkbookEvents_SyncEventHandler Delegate
WorkbookEvents_WindowActivateEventHandler Delegate
WorkbookEvents_WindowDeactivateEventHandler Delegate
WorkbookEvents_WindowResizeEventHandler Delegate
Workbooks Interface
Worksheet Interface
WorksheetClass Class
WorksheetFunction Interface
Worksheets Interface
XlApplicationInternational Enumeration
XlApplyNamesOrder Enumeration
XlArabicModes Enumeration
XlArrangeStyle Enumeration
XlArrowHeadLength Enumeration
XlArrowHeadStyle Enumeration
XlArrowHeadWidth Enumeration
XlAutoFillType Enumeration
XlAutoFilterOperator Enumeration
XlAxisCrosses Enumeration
XlAxisGroup Enumeration
XlAxisType Enumeration
XlBackground Enumeration
XlBarShape Enumeration
XlBordersIndex Enumeration
XlBorderWeight Enumeration
XlBuiltInDialog Enumeration
XlCalculatedMemberType Enumeration
XlCalculation Enumeration
XlCalculationInterruptKey Enumeration
XlCalculationState Enumeration
XlCategoryType Enumeration
XlCellInsertionMode Enumeration
XlCellType Enumeration
XlChartGallery Enumeration
XlChartItem Enumeration
XlChartLocation Enumeration
XlChartPicturePlacement Enumeration
XlChartPictureType Enumeration
XlChartSplitType Enumeration
XlChartType Enumeration
XlClipboardFormat Enumeration
XlCmdType Enumeration
XlColorIndex Enumeration
XlColumnDataType Enumeration
XlCommandUnderlines Enumeration
XlCommentDisplayMode Enumeration
XlConsolidationFunction Enumeration
XlCopyPictureFormat Enumeration
XlCorruptLoad Enumeration
XlCreator Enumeration
XlCubeFieldType Enumeration
XlCutCopyMode Enumeration
XlCVError Enumeration
XlDataLabelPosition Enumeration
XlDataLabelSeparator Enumeration
XlDataLabelsType Enumeration
XlDataSeriesDate Enumeration
XlDataSeriesType Enumeration
XlDeleteShiftDirection Enumeration
XlDirection Enumeration
XlDisplayBlanksAs Enumeration
XlDisplayDrawingObjects Enumeration
XlDisplayUnit Enumeration
XlDVAlertStyle Enumeration
XlDVType Enumeration
XlEditionFormat Enumeration
XlEditionOptionsOption Enumeration
XlEditionType Enumeration
XlEnableCancelKey Enumeration
XlEnableSelection Enumeration
XlEndStyleCap Enumeration
XlErrorBarDirection Enumeration
XlErrorBarInclude Enumeration
XlErrorBarType Enumeration
XlErrorChecks Enumeration
XlFileAccess Enumeration
XlFileFormat Enumeration
XlFillWith Enumeration
XlFilterAction Enumeration
XlFindLookIn Enumeration
XlFormatConditionOperator Enumeration
XlFormatConditionType Enumeration
XlFormControl Enumeration
XlFormulaLabel Enumeration
XlHAlign Enumeration
XlHebrewModes Enumeration
XlHighlightChangesTime Enumeration
XlHtmlType Enumeration
XlIMEMode Enumeration
XlImportDataAs Enumeration
XlInsertFormatOrigin Enumeration
XlInsertShiftDirection Enumeration
XlLayoutFormType Enumeration
XlLegendPosition Enumeration
XlLineStyle Enumeration
XlLink Enumeration
XlLinkInfo Enumeration
XlLinkInfoType Enumeration
XlLinkStatus Enumeration
XlLinkType Enumeration
XlListConflict Enumeration
XlListDataType Enumeration
XlListObjectSourceType Enumeration
XlLocationInTable Enumeration
XlLookAt Enumeration
XlMailSystem Enumeration
XlMarkerStyle Enumeration
XlMouseButton Enumeration
XlMousePointer Enumeration
XlMSApplication Enumeration
XlObjectSize Enumeration
XlOLEType Enumeration
XlOLEVerb Enumeration
XlOrder Enumeration
XlOrientation Enumeration
XlPageBreak Enumeration
XlPageBreakExtent Enumeration
XlPageOrientation Enumeration
XlPaperSize Enumeration
XlParameterDataType Enumeration
XlParameterType Enumeration
XlPasteSpecialOperation Enumeration
XlPasteType Enumeration
XlPattern Enumeration
XlPhoneticAlignment Enumeration
XlPhoneticCharacterType Enumeration
XlPictureAppearance Enumeration
XlPictureConvertorType Enumeration
XlPivotCellType Enumeration
XlPivotFieldCalculation Enumeration
XlPivotFieldDataType Enumeration
XlPivotFieldOrientation Enumeration
XlPivotFormatType Enumeration
XlPivotTableMissingItems Enumeration
XlPivotTableSourceType Enumeration
XlPivotTableVersionList Enumeration
XlPlacement Enumeration
XlPlatform Enumeration
XlPrintErrors Enumeration
XlPrintLocation Enumeration
XlPriority Enumeration
XlPTSelectionMode Enumeration
XlQueryType Enumeration
XlRangeAutoFormat Enumeration
XlRangeValueDataType Enumeration
XlReferenceStyle Enumeration
XlReferenceType Enumeration
XlRobustConnect Enumeration
XlRoutingSlipDelivery Enumeration
XlRoutingSlipStatus Enumeration
XlRowCol Enumeration
XlRunAutoMacro Enumeration
XlSaveAction Enumeration
XlSaveAsAccessMode Enumeration
XlSaveConflictResolution Enumeration
XlScaleType Enumeration
XlSearchDirection Enumeration
XlSearchOrder Enumeration
XlSearchWithin Enumeration
XlSheetType Enumeration
XlSheetVisibility Enumeration
XlSizeRepresents Enumeration
XlSmartTagControlType Enumeration
XlSmartTagDisplayMode Enumeration
XlSortDataOption Enumeration
XlSortMethod Enumeration
XlSortMethodOld Enumeration
XlSortOrder Enumeration
XlSortOrientation Enumeration
XlSortType Enumeration
XlSourceType Enumeration
XlSpeakDirection Enumeration
XlSpecialCellsValue Enumeration
XlSubscribeToFormat Enumeration
XlSubtototalLocationType Enumeration
XlSummaryColumn Enumeration
XlSummaryReportType Enumeration
XlSummaryRow Enumeration
XlTabPosition Enumeration
XlTextParsingType Enumeration
XlTextQualifier Enumeration
XlTextVisualLayoutType Enumeration
XlTickLabelOrientation Enumeration
XlTickLabelPosition Enumeration
XlTickMark Enumeration
XlTimeUnit Enumeration
XlToolbarProtection Enumeration
XlTotalsCalculation Enumeration
XlTrendlineType Enumeration
XlUnderlineStyle Enumeration
XlUpdateLinks Enumeration
XlVAlign Enumeration
XlWBATemplate Enumeration
XlWebFormatting Enumeration
XlWebSelectionType Enumeration
XlWindowState Enumeration
XlWindowType Enumeration
XlWindowView Enumeration
XlXLMMacroType Enumeration
XlXmlExportResult Enumeration
XlXmlImportResult Enumeration
XlXmlLoadOption Enumeration
XlYesNoGuess Enumeration
XmlDataBinding Interface
XmlMap Interface
XmlMaps Interface
XmlNamespace Interface
XmlNamespaces Interface
XmlSchema Interface
XmlSchemas Interface
XPath Interface
Erweitern Minimieren

Microsoft.Office.Interop.Excel Namespace

InterfaceDescription
_ApplicationRepresents the entire Microsoft Excel application.
_ChartRepresents a chart in a workbook. The chart can be either an embedded chart (contained in a ChartObject) or a separate chart sheet.
_Global 
_IOLEObject 
_IQueryTable 
_OLEObjectRepresents an ActiveX control or a linked or embedded OLE object on a worksheet. The OLEObject object is a member of the OLEObjects collection. The OLEObjects collection contains all the OLE objects on a single worksheet.
_QueryTableRepresents a worksheet table built from data returned from an external data source, such as a SQL server or a Microsoft Access database. The QueryTable object is a member of the QueryTables collection.
_WorkbookRepresents a Microsoft Excel workbook.
_WorksheetRepresents a worksheet.
AddInRepresents a single add-in, either installed or not installed.
AddInsA collection of AddIn objects that represents all the add-ins available to Microsoft Excel, regardless of whether they’re installed. This list corresponds to the list of add-ins displayed in the Add-Ins dialog box (Tools menu).
AdjustmentsContains a collection of adjustment values for the specified AutoShape, WordArt object, or connector.
AllowEditRangeRepresents the cells that can be edited on a protected worksheet.
AllowEditRangesA collection of all the AllowEditRange objects that represent the cells that can be edited on a protected worksheet.
AppEvents 
AppEvents_EventEvents interface for Microsoft Excel Application object events.
ApplicationRepresents the entire Microsoft Excel application.
Arc 
Arcs 
AreasA collection of the areas, or contiguous blocks of cells, within a selection.
AutoCorrectContains Microsoft Excel AutoCorrect attributes (capitalization of names of days, correction of two initial capital letters, automatic correction list, and so on).
AutoFilterRepresents autofiltering for the specified worksheet.
AutoRecoverRepresents the automatic recovery features of a workbook.
AxesA collection of all the Axis objects in the specified chart.
AxisRepresents a single axis in a chart.
AxisTitleRepresents a chart axis title.
BorderRepresents the border of an object.
BordersA collection of four Border objects that represent the four borders of a Range or Style object.
Button 
Buttons 
CalculatedFieldsA collection of PivotField objects that represents all the calculated fields in the specified PivotTable report.
CalculatedItemsA collection of PivotItem objects that represent all the calculated items in the specified PivotTable report.
CalculatedMemberRepresents the calculated fields and calculated items for PivotTables with Online Analytical Processing (OLAP) data sources.
CalculatedMembersA collection of all the CalculatedMember objects on the specified PivotTable. Each CalculatedMember object represents a calculated member or calculated measure.
CalloutFormatContains properties and methods that apply to line callouts.
CellFormatRepresents the search criteria for the cell format.
CharactersRepresents characters in an object that contains text. The Characters object lets you modify any sequence of characters contained in the full text string.
ChartRepresents a chart in a workbook. The chart can be either an embedded chart (contained in a ChartObject) or a separate chart sheet.
ChartAreaRepresents the chart area of a chart. The chart area on a 2-D chart contains the axes, the chart title, the axis titles, and the legend. The chart area on a 3-D chart contains the chart title and the legend; it doesn’t include the plot area (the area within the chart area where the data is plotted). For information about formatting the plot area, see the PlotArea object.
ChartColorFormatUsed only with charts. Represents the color of a one-color object or the foreground or background color of an object with a gradient or patterned fill.
ChartEvents 
ChartEvents_EventEvents interface for Microsoft Excel Chart object events.
ChartFillFormatUsed only with charts. Represents fill formatting for chart elements.
ChartGroupRepresents one or more series plotted in a chart with the same format. The ChartGroup object is a member of the ChartGroups collection.
ChartGroupsA collection of all the ChartGroup objects in the specified chart.
ChartObjectRepresents an embedded chart on a worksheet.
ChartObjectsA collection of all the ChartObject objects on the specified chart sheet, dialog sheet, or worksheet.
ChartsA collection of all the chart sheets in the specified or active workbook. Each chart sheet is represented by a Chart object. This doesn’t include charts embedded on worksheets or dialog sheets. For information about embedded charts, see the ChartObject object.
ChartTitleRepresents the chart title.
CheckBox 
CheckBoxes 
ColorFormatRepresents the color of a one-color object, the foreground or background color of an object with a gradient or patterned fill, or the pointer color.
CommentRepresents a cell comment.
CommentsA collection of cell comments. Each comment is represented by a Comment object.
ConnectorFormatContains properties and methods that apply to connectors.
ControlFormatContains Microsoft Excel control properties.
CornersRepresents the corners of a 3-D chart.
CubeFieldRepresents a hierarchy or measure field from an OLAP cube.
CubeFieldsA collection of all CubeField objects in a PivotTable report that is based on an OLAP cube.
CustomPropertiesA collection of CustomProperty objects that represent additional information. The information can be used as metadata for XML.
CustomPropertyRepresents identifier information. Identifier information can be used as metadata for XML.
CustomViewRepresents a custom workbook view.
CustomViewsA collection of custom workbook views. Each view is represented by a CustomView object.
DataLabelRepresents the data label on a chart point or trendline.
DataLabelsA collection of all the DataLabel objects for the specified series. Each DataLabel object represents a data label for a point or trendline. For a series without definable points (such as an area series), the DataLabels collection contains a single data label.
DataTableRepresents a chart data table.
DefaultWebOptionsContains global application-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page.
DiagramRepresents a diagram.
DiagramNodeRepresents a node in a diagram.
DiagramNodeChildrenA collection of DiagramNode objects that represents child nodes in a diagram.
DiagramNodesA collection of DiagramNode objects that represents all the nodes in a diagram.
DialogRepresents a built-in Microsoft Excel dialog box.
DialogFrame 
DialogsA collection of all the Dialog objects in Microsoft Excel.
DialogSheet 
DialogSheets 
DisplayUnitLabelRepresents a unit label on an axis in the specified chart.
DocEvents 
DocEvents_EventEvents interface for Microsoft Excel Worksheet object events.
DownBarsRepresents the down bars in a chart group.
Drawing 
DrawingObjects 
Drawings 
DropDown 
DropDowns 
DropLinesRepresents the drop lines in a chart group.
EditBox 
EditBoxes 
ErrorRepresents a spreadsheet error for a range.
ErrorBarsRepresents the error bars on a chart series.
ErrorCheckingOptionsRepresents the error-checking options for an application.
ErrorsRepresents the various spreadsheet errors for a range.
FillFormatRepresents fill formatting for a shape.
FilterRepresents a filter for a single column. The Filter object is a member of the Filters collection. The Filters collection contains all the filters in an autofiltered range.
FiltersA collection of Filter objects that represents all the filters in an autofiltered range.
FloorRepresents the floor of a 3-D chart.
FontContains the font attributes (font name, font size, color, and so on) for an object.
FormatConditionRepresents a conditional format.
FormatConditionsRepresents the collection of conditional formats for a single range.
FreeformBuilderRepresents the geometry of a freeform while it’s being built.
Global 
GraphicContains properties that apply to header and footer picture objects.
GridlinesRepresents major or minor gridlines on a chart axis.
GroupBox 
GroupBoxes 
GroupObject 
GroupObjects 
GroupShapesRepresents the individual shapes within a grouped shape.
HiLoLinesRepresents the high-low lines in a chart group.
HPageBreakRepresents a horizontal page break.
HPageBreaksThe collection of horizontal page breaks within the print area. Each horizontal page break is represented by an HPageBreak object.
HyperlinkRepresents a hyperlink.
HyperlinksRepresents the collection of hyperlinks for a worksheet or range. Each hyperlink is represented by a Hyperlink object.
IAddIn 
IAddIns 
IAllowEditRange 
IAllowEditRanges 
IAppEvents 
IArc 
IArcs 
IAreas 
IAutoCorrect 
IAutoFilter 
IAutoRecover 
IAxes 
IAxis 
IAxisTitle 
IBorder 
IBorders 
IButton 
IButtons 
ICalculatedFields 
ICalculatedItems 
ICalculatedMember 
ICalculatedMembers 
ICanvasShapes 
ICellFormat 
ICharacters 
IChartArea 
IChartColorFormat 
IChartEvents 
IChartFillFormat 
IChartGroup 
IChartGroups 
IChartObject 
IChartObjects 
ICharts 
IChartTitle 
ICheckBox 
ICheckBoxes 
IComment 
IComments 
IConnectorFormat 
IControlFormat 
ICorners 
ICustomProperties 
ICustomProperty 
ICustomView 
ICustomViews 
IDataLabel 
IDataLabels 
IDataTable 
IDiagram 
IDialog 
IDialogFrame 
IDialogs 
IDialogSheet 
IDialogSheets 
IDisplayUnitLabel 
IDocEvents 
IDownBars 
IDrawing 
IDrawingObjects 
IDrawings 
IDropDown 
IDropDowns 
IDropLines 
IDummy 
IEditBox 
IEditBoxes 
IError 
IErrorBars 
IErrorCheckingOptions 
IErrors 
IFilter 
IFilters 
IFloor 
IFont 
IFormatCondition 
IFormatConditions 
IFreeformBuilder 
IGraphic 
IGridlines 
IGroupBox 
IGroupBoxes 
IGroupObject 
IGroupObjects 
IGroupShapes 
IHiLoLines 
IHPageBreak 
IHPageBreaks 
IHyperlink 
IHyperlinks 
IInterior 
ILabel 
ILabels 
ILeaderLines 
ILegend 
ILegendEntries 
ILegendEntry 
ILegendKey 
ILine 
ILines 
ILinkFormat 
IListBox 
IListBoxes 
IListColumn 
IListColumns 
IListDataFormat 
IListObject 
IListObjects 
IListRow 
IListRows 
IMailer 
IMenu 
IMenuBar 
IMenuBars 
IMenuItem 
IMenuItems 
IMenus 
IModule 
IModules 
IName 
INames 
InteriorRepresents the interior of an object.
IODBCError 
IODBCErrors 
IOLEDBError 
IOLEDBErrors 
IOLEFormat 
IOLEObjectEvents 
IOLEObjects 
IOptionButton 
IOptionButtons 
IOutline 
IOval 
IOvals 
IPageSetup 
IPane 
IPanes 
IParameter 
IParameters 
IPhonetic 
IPhonetics 
IPicture 
IPictures 
IPivotCache 
IPivotCaches 
IPivotCell 
IPivotField 
IPivotFields 
IPivotFormula 
IPivotFormulas 
IPivotItem 
IPivotItemList 
IPivotItems 
IPivotLayout 
IPivotTable 
IPivotTables 
IPlotArea 
IPoint 
IPoints 
IProtection 
IPublishObjects 
IQueryTables 
IRange 
IRecentFile 
IRecentFiles 
IRectangle 
IRectangles 
IRefreshEvents 
IRoutingSlip 
IRTD 
IRtdServerRepresents an interface for a real-time data server.
IRTDUpdateEventRepresents real-time data update events.
IScenario 
IScenarios 
IScrollBar 
IScrollBars 
ISeries 
ISeriesCollection 
ISeriesLines 
IShape 
IShapeRange 
IShapes 
ISmartTag 
ISmartTagAction 
ISmartTagActions 
ISmartTagOptions 
ISmartTagRecognizer 
ISmartTagRecognizers 
ISmartTags 
ISoundNote 
ISpeech 
ISpellingOptions 
ISpinner 
ISpinners 
IStyle 
IStyles 
ITab 
ITextBox 
ITextBoxes 
ITextFrame 
ITickLabels 
IToolbar 
IToolbarButton 
IToolbarButtons 
IToolbars 
ITrendline 
ITrendlines 
IUpBars 
IUsedObjects 
IUserAccess 
IUserAccessList 
IValidation 
IVPageBreak 
IVPageBreaks 
IWalls 
IWatch 
IWatches 
IWindow 
IWindows 
IWorkbookEvents 
IWorksheetFunction 
IWorksheets 
IXmlDataBinding 
IXmlMap 
IXmlMaps 
IXmlNamespace 
IXmlNamespaces 
IXmlSchema 
IXmlSchemas 
IXPath 
Label 
Labels 
LeaderLinesRepresents leader lines on a chart.
LegendRepresents the legend in a chart.
LegendEntriesA collection of all the LegendEntry objects in the specified chart legend.
LegendEntryRepresents a legend entry in a chart legend.
LegendKeyRepresents a legend key in a chart legend.
Line 
LineFormatRepresents line and arrowhead formatting.
Lines 
LinkFormatContains linked OLE object properties.
ListBox 
ListBoxes 
ListColumnRepresents a column in a list. The ListColumn object is a member of the ListColumns collection. The ListColumns collection contains all the columns in a list (ListObject object).
ListColumnsA collection of all the ListColumn objects in the specified ListObject object. Each ListColumn object represents a column in the list.
ListDataFormatThe ListDataFormat object holds all the data type properties of the ListColumn object. These properties are read-only.
ListObjectRepresents a list object on a worksheet.
ListObjectsA collection of all the ListObject objects on a worksheet. Each ListObject object represents a list in the worksheet.
ListRowRepresents a row in a List object. The ListRow object is a member of the ListRows collection. The ListRows collection contains all the rows in a list object.
ListRowsA collection of all the ListRow objects in the specified ListObject object. Each ListRow object represents a row in the list.
MailerYou have requested Help for a Visual Basic keyword used only on the Macintosh. For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition.
Menu 
MenuBar 
MenuBars 
MenuItem 
MenuItems 
Menus 
Module 
Modules 
NameRepresents a defined name for a range of cells.
NamesA collection of all the Name objects in the application or workbook. Each Name object represents a defined name for a range of cells. Names can be either built-in names — such as Database, Print_Area, and Auto_Open — or custom names.
ODBCErrorRepresents an ODBC error generated by the most recent ODBC query.
ODBCErrorsA collection of ODBCError objects.
OLEDBErrorRepresents an OLE DB error returned by the most recent OLE DB query.
OLEDBErrorsA collection of OLEDBError objects.
OLEFormatContains OLE object properties.
OLEObjectRepresents an ActiveX control or a linked or embedded OLE object on a worksheet. The OLEObject object is a member of the OLEObjects collection. The OLEObjects collection contains all the OLE objects on a single worksheet.
OLEObjectEvents 
OLEObjectEvents_EventEvents interface for Microsoft Excel OLEObject object events.
OLEObjectsA collection of all the OLEObject objects on the specified worksheet. Each OLEObject object represents an ActiveX control or a linked or embedded OLE object.
OptionButton 
OptionButtons 
OutlineRepresents an outline on a worksheet.
Oval 
Ovals 
PageSetupRepresents the page setup description. The PageSetup object contains all page setup attributes (left margin, bottom margin, paper size, and so on) as properties.
PaneRepresents a pane of a window.
PanesA collection of all the Pane objects shown in the specified window.
ParameterRepresents a single parameter used in a parameter query. The Parameter object is a member of the Parameters collection.
ParametersA collection of Parameter objects for the specified query table. Each Parameter object represents a single query parameter. Every query table contains a Parameters collection, but the collection is empty unless the query table is using a parameter query.
PhoneticContains information about a specific phonetic text string in a cell.
PhoneticsA collection of all the Phonetic objects in the specified range. Each Phonetic object contains information about a specific phonetic text string.
Picture 
PictureFormatContains properties and methods that apply to pictures and OLE objects.
Pictures 
PivotCacheRepresents the memory cache for a PivotTable report.
PivotCachesRepresents the collection of memory caches from the PivotTable reports in a workbook.
PivotCellRepresents a cell in a PivotTable report.
PivotFieldRepresents a field in a PivotTable report. The PivotField object is a member of the PivotFields collection. The PivotFields collection contains all the fields in a PivotTable report, including hidden fields.
PivotFieldsA collection of all the PivotField objects in a PivotTable report.
PivotFormulaRepresents a formula used to calculate results in a PivotTable report.
PivotFormulasRepresents the collection of formulas for a PivotTable report. Each formula is represented by a PivotFormula object.
PivotItemRepresents an item in a PivotTable field. The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems collection. The PivotItems collection contains all the items in a PivotField object.
PivotItemListA collection of all the PivotItem objects in the specified PivotTable. Each PivotItem represents an item in a PivotTable field.
PivotItemsA collection of all the PivotItem objects in a PivotTable field. The items are the individual data entries in a field category.
PivotLayoutRepresents the placement of fields in a PivotChart report.
PivotTableRepresents a PivotTable report on a worksheet. The PivotTable object is a member of the PivotTables collection. The PivotTables collection contains all the PivotTable objects on a single worksheet.
PivotTablesA collection of all the PivotTable objects on the specified worksheet.
PlotAreaRepresents the plot area of a chart. This is the area where your chart data is plotted.
PointRepresents a single point in a series in a chart.
PointsA collection of all the Point objects in the specified series in a chart.
ProtectionRepresents the various types of protection options available for a worksheet.
PublishObjectRepresents an item in a workbook that has been saved to a Web page and can be refreshed according to values specified by the properties and methods of the PublishObject object.
PublishObjectsA collection of all PublishObject objects in the workbook. Each PublishObject object represents an item in a workbook that has been saved to a Web page and can be refreshed according to values specified by the properties and methods of the object.
QueryTableRepresents a worksheet table built from data returned from an external data source, such as a SQL server or a Microsoft Access database. The QueryTable object is a member of the QueryTables collection.
QueryTablesA collection of QueryTable objects. Each QueryTable object represents a worksheet table built from data returned from an external data source.
RangeRepresents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.
RecentFileRepresents a file in the list of recently used files.
RecentFilesRepresents the list of recently used files. Each file is represented by a RecentFile object.
Rectangle 
Rectangles 
RefreshEvents 
RefreshEvents_EventEvents interface for Microsoft Excel QueryTable object events.
RoutingSlipRepresents the routing slip for a workbook. The routing slip is used to send a workbook through the electronic mail system.
RTDRepresents a real-time data object.
ScenarioRepresents a scenario on a worksheet. A scenario is a group of input values (called changing cells) that’s named and saved.
ScenariosA collection of all the Scenario objects on the specified worksheet. A scenario is a group of input values (called changing cells) that’s named and saved.
ScrollBar 
ScrollBars 
SeriesRepresents a series in a chart. The Series object is a member of the SeriesCollection collection.
SeriesCollectionA collection of all the Series objects in the specified chart or chart group.
SeriesLinesRepresents series lines in a chart group. Series lines connect the data values from each series.
ShadowFormatRepresents shadow formatting for a shape.
ShapeRepresents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture. The Shape object is a member of the Shapes collection. The Shapes collection contains all the shapes on a slide.
ShapeNodeRepresents the geometry and the geometry-editing properties of the nodes in a user-defined freeform.
ShapeNodesA collection of all the ShapeNode objects in the specified freeform.
ShapeRangeRepresents a shape range, which is a set of shapes on a document.
ShapesA collection of all the Shape objects on the specified sheet. Each Shape object represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture.
SheetsA collection of all the sheets in the specified or active workbook.
SmartTagRepresents an identifier that is assigned to a cell.
SmartTagActionRepresents the actions that can be performed with smart tags.
SmartTagActionsA collection of SmartTagAction objects that represent the actions that can be performed with smart tags.
SmartTagOptionsRepresents the options that can be performed with smart tags.
SmartTagRecognizerRepresents recognition engines which label data with types of information as you work in Microsoft Excel.
SmartTagRecognizersA collection of SmartTagRecognizer objects that represent recognition engines that label data with types of information as you work in Microsoft Excel.
SmartTagsA collection of SmartTag objects that represent the identifiers assigned to each cell.
SoundNoteThis object should not be used. Sound notes have been removed from Microsoft Excel.
SpeechContains methods and properties that pertain to speech.
SpellingOptionsRepresents the various spell-checking options for a worksheet.
Spinner 
Spinners 
StyleRepresents a style description for a range.
StylesA collection of all the Style objects in the specified or active workbook.
TabRepresents a tab in a chart or a worksheet.
TextBox 
TextBoxes 
TextEffectFormatContains properties and methods that apply to WordArt objects.
TextFrameRepresents the text frame in a Shape object. Contains the text in the text frame as well as the properties and methods that control the alignment and anchoring of the text frame.
ThreeDFormatRepresents a shape's three-dimensional formatting.
TickLabelsRepresents the tick mark labels associated with tick marks on a chart axis.
Toolbar 
ToolbarButton 
ToolbarButtons 
Toolbars 
TreeviewControlRepresents the hierarchical member-selection control of a cube field. You use this object primarily for macro recording; it is not intended for any other use.
TrendlineRepresents a trendline in a chart. A trendline shows the trend, or direction, of data in a series.
TrendlinesA collection of all the Trendline objects for the specified series. Each Trendline object represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series.
UpBarsRepresents the up bars in a chart group. Up bars connect points on series one with higher values on the last series in the chart group (the lines go up from series one).
UsedObjectsRepresents objects that have been allocated in a workbook.
UserAccessRepresents the user access for a protected range.
UserAccessListA collection of UserAccess objects that represent the user access for protected ranges.
ValidationRepresents data validation for a worksheet range.
VPageBreakRepresents a vertical page break.
VPageBreaksA collection of vertical page breaks within the print area. Each vertical page break is represented by a VPageBreak object.
WallsRepresents the walls of a 3-D chart.
WatchRepresents a range which is tracked when the worksheet is recalculated.
WatchesA collection of all the Watch objects in a specified application.
WebOptionsContains workbook-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page.
WindowRepresents a window. Many worksheet characteristics, such as scroll bars and gridlines, are actually properties of the window.
WindowsA collection of all the Window objects in Microsoft Excel.
WorkbookRepresents a Microsoft Excel workbook.
WorkbookEvents 
WorkbookEvents_EventEvents interface for Microsoft Excel Workbook object events.
WorkbooksA collection of all the Workbook objects that are currently open in the Microsoft Excel application.
WorksheetRepresents a worksheet.
WorksheetFunctionUsed as a container for Microsoft Excel worksheet functions
WorksheetsA collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet.
XmlDataBindingRepresents the connection to the source data for an XmlMap object.
XmlMapRepresents an XML map that has been added to a workbook.
XmlMapsRepresents the collection of XmlMap objects that have been added to a workbook.
XmlNamespaceRepresents a namespace that has been added to a workbook.
XmlNamespacesRepresents the collection of XmlNamespace objects in a workbook.
XmlSchemaRepresents an XML schema contained by an XmlMap object.
XmlSchemasRepresents the collection of XmlSchema objects contained by an XmlMap object.
XPathRepresents an XPath that has been mapped to a Range or ListColumn object.

DelegateDescription
AppEvents_NewWorkbookEventHandlerA Delegate type used to add an event handler for the NewWorkbook event. The NewWorkbook event occurs when a new workbook is created.
AppEvents_SheetActivateEventHandlerA Delegate type used to add an event handler for the SheetActivate event. The SheetActivate event occurs when any sheet is activated.
AppEvents_SheetBeforeDoubleClickEventHandlerA Delegate type used to add an event handler for the SheetBeforeDoubleClick event. The SheetBeforeDoubleClick event occurs when any worksheet is double-clicked, before the default double-click action.
AppEvents_SheetBeforeRightClickEventHandlerA Delegate type used to add an event handler for the SheetBeforeRightClick event. The SheetBeforeRightClick event occurs when any worksheet is right-clicked, before the default right-click action.
AppEvents_SheetCalculateEventHandlerA Delegate type used to add an event handler for the SheetCalculate event. The SheetCalculate event occurs after any worksheet is recalculated or after any changed data is plotted on a chart.
AppEvents_SheetChangeEventHandlerA Delegate type used to add an event handler for the SheetChange event. The SheetChange event occurs when cells in any worksheet are changed by the user or by an external link.
AppEvents_SheetDeactivateEventHandlerA Delegate type used to add an event handler for the SheetDeactivate event. The SheetDeactivate event occurs when any sheet is deactivated.
AppEvents_SheetFollowHyperlinkEventHandlerA Delegate type used to add an event handler for the SheetFollowHyperlink event. The SheetFollowHyperlink event occurs when you click any hyperlink in Microsoft Excel.
AppEvents_SheetPivotTableUpdateEventHandlerA Delegate type used to add an event handler for the SheetPivotTableUpdate event. The SheetPivotTableUpdate event occurs after the sheet of the PivotTable report has been updated.
AppEvents_SheetSelectionChangeEventHandlerA Delegate type used to add an event handler for the SheetSelectionChange event. The SheetSelectionChange event occurs when the selection changes on any worksheet.
AppEvents_WindowActivateEventHandlerA Delegate type used to add an event handler for the WindowActivate event. The WindowActivate event occurs when any workbook window is activated.
AppEvents_WindowDeactivateEventHandlerA Delegate type used to add an event handler for the WindowDeactivate event. The WindowDeactivate event occurs when any workbook window is deactivated.
AppEvents_WindowResizeEventHandlerA Delegate type used to add an event handler for the WindowResize event. The WindowResize event occurs when any workbook window is resized.
AppEvents_WorkbookActivateEventHandlerA Delegate type used to add an event handler for the WorkbookActivate event. The WorkbookActivate event occurs when any workbook is activated.
AppEvents_WorkbookAddinInstallEventHandlerA Delegate type used to add an event handler for the WorkbookAddinInstall event. The WorkbookAddinInstall event occurs when a workbook is installed as an add-in.
AppEvents_WorkbookAddinUninstallEventHandlerA Delegate type used to add an event handler for the WorkbookAddinUninstall event. The WorkbookAddinUninstall event occurs when any add-in workbook is uninstalled.
AppEvents_WorkbookAfterXmlExportEventHandlerA Delegate type used to add an event handler for the WorkbookAfterXmlExport event. The WorkbookAfterXmlExport event occurs after Microsoft Excel saves or exports data from any open workbook to an XML data file.
AppEvents_WorkbookAfterXmlImportEventHandlerA Delegate type used to add an event handler for the WorkbookAfterXmlImport event. The WorkbookAfterXmlImport event occurs after an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook.
AppEvents_WorkbookBeforeCloseEventHandlerA Delegate type used to add an event handler for the WorkbookBeforeClose event. The WorkbookBeforeClose event occurs immediately before any open workbook closes.
AppEvents_WorkbookBeforePrintEventHandlerA Delegate type used to add an event handler for the WorkbookBeforePrint event. The WorkbookBeforePrint event occurs before any open workbook is printed.
AppEvents_WorkbookBeforeSaveEventHandlerA Delegate type used to add an event handler for the WorkbookBeforeSave event. The WorkbookBeforeSave event occurs before any open workbook is saved.
AppEvents_WorkbookBeforeXmlExportEventHandlerA Delegate type used to add an event handler for the WorkbookBeforeXmlExport event. The WorkbookBeforeXmlExport event occurs before Microsoft Excel saves or exports data from any open workbook to an XML data file.
AppEvents_WorkbookBeforeXmlImportEventHandlerA Delegate type used to add an event handler for the WorkbookBeforeXmlImport event. The WorkbookBeforeXmlImport event occurs before an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook.
AppEvents_WorkbookDeactivateEventHandlerA Delegate type used to add an event handler for the WorkbookDeactivate event. The WorkbookDeactivate event occurs when any open workbook is deactivated.
AppEvents_WorkbookNewSheetEventHandlerA Delegate type used to add an event handler for the WorkbookNewSheet event. The WorkbookNewSheet event occurs when a new sheet is created in any open workbook.
AppEvents_WorkbookOpenEventHandlerA Delegate type used to add an event handler for the WorkbookOpen event. The WorkbookOpen event occurs when a workbook is opened.
AppEvents_WorkbookPivotTableCloseConnectionEventHandlerA Delegate type used to add an event handler for the WorkbookPivotTableCloseConnection event. The WorkbookPivotTableCloseConnection event occurs after a PivotTable report connection has been closed.
AppEvents_WorkbookPivotTableOpenConnectionEventHandlerA Delegate type used to add an event handler for the WorkbookPivotTableOpenConnection event. The WorkbookPivotTableOpenConnection event occurs after a PivotTable report connection has been opened.
AppEvents_WorkbookSyncEventHandlerA Delegate type used to add an event handler for the WorkbookSync event. The WorkbookSync event occurs when the local copy of a workbook that is part of a Document Workspace is synchronized with the copy on the server.
ChartEvents_ActivateEventHandlerA Delegate type used to add an event handler for the Activate event. The Activate event occurs when a chart sheet or embedded chart is activated.
ChartEvents_BeforeDoubleClickEventHandlerA Delegate type used to add an event handler for the BeforeDoubleClick event. The BeforeDoubleClick event occurs when an embedded chart is double-clicked, before the default double-click action.
ChartEvents_BeforeRightClickEventHandlerA Delegate type used to add an event handler for the BeforeRightClick event. The BeforeRightClick event occurs when an embedded chart is right-clicked, before the default right-click action.
ChartEvents_CalculateEventHandlerA Delegate type used to add an event handler for the Calculate event. The Calculate event occurs after the chart plots new or changed data.
ChartEvents_DeactivateEventHandlerA Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the chart is deactivated.
ChartEvents_DragOverEventHandlerA Delegate type used to add an event handler for the DragOver event. The DragOver event occurs when a range of cells is dragged over a chart.
ChartEvents_DragPlotEventHandlerA Delegate type used to add an event handler for the DragPlot event. The DragPlot event occurs when a range of cells is dragged and dropped on a chart.
ChartEvents_MouseDownEventHandlerA Delegate type used to add an event handler for the MouseDown event. The MouseDown event occurs when a mouse button is pressed while the pointer is over a chart.
ChartEvents_MouseMoveEventHandlerA Delegate type used to add an event handler for the MouseMove event. The MouseMove event occurs when the position of the mouse pointer changes over a chart.
ChartEvents_MouseUpEventHandlerA Delegate type used to add an event handler for the MouseUp event. The MouseUp event occurs when a mouse button is released while the pointer is over a chart.
ChartEvents_ResizeEventHandlerA Delegate type used to add an event handler for the Resize event. The Resize event occurs when the chart is resized.
ChartEvents_SelectEventHandlerA Delegate type used to add an event handler for the Select event. The Select event occurs when a chart element is selected.
ChartEvents_SeriesChangeEventHandlerA Delegate type used to add an event handler for the SeriesChange event. The SeriesChange event occurs when the user changes the value of a chart data point.
DocEvents_ActivateEventHandlerA Delegate type used to add an event handler for the Activate event. The Activate event occurs when a worksheet is activated.
DocEvents_BeforeDoubleClickEventHandlerA Delegate type used to add an event handler for the BeforeDoubleClick event. The BeforeDoubleClick event occurs when a worksheet is double-clicked, before the default double-click action.
DocEvents_BeforeRightClickEventHandlerA Delegate type used to add an event handler for the BeforeRightClick event. The BeforeRightClick event occurs when a worksheet is right-clicked, before the default right-click action.
DocEvents_CalculateEventHandlerA Delegate type used to add an event handler for the Calculate event. The Calculate event occurs after the worksheet is recalculated.
DocEvents_ChangeEventHandlerA Delegate type used to add an event handler for the Change event. The Change event occurs when cells on the worksheet are changed by the user or by an external link.
DocEvents_DeactivateEventHandlerA Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the worksheet is deactivated.
DocEvents_FollowHyperlinkEventHandlerA Delegate type used to add an event handler for the FollowHyperlink event. The FollowHyperlink event occurs when you click any hyperlink on a worksheet.
DocEvents_PivotTableUpdateEventHandlerA Delegate type used to add an event handler for the PivotTableUpdate event. The PivotTableUpdate event occurs after a PivotTable report is updated on a worksheet.
DocEvents_SelectionChangeEventHandlerA Delegate type used to add an event handler for the SelectionChange event. The SelectionChange event occurs when the selection changes on a worksheet.
OLEObjectEvents_GotFocusEventHandlerA Delegate type used to add an event handler for the GotFocus event. The GotFocus event occurs when an ActiveX control gets input focus.
OLEObjectEvents_LostFocusEventHandlerA Delegate type used to add an event handler for the LostFocus event. The LostFocus event occurs when an ActiveX control loses input focus.
RefreshEvents_AfterRefreshEventHandlerA Delegate type used to add an event handler for the AfterRefresh event. The AfterRefresh event occurs after a query is completed or canceled.
RefreshEvents_BeforeRefreshEventHandlerA Delegate type used to add an event handler for the BeforeRefresh event. The BeforeRefresh event occurs before any refreshes of the query table.
WorkbookEvents_ActivateEventHandlerA Delegate type used to add an event handler for the Activate event. The Activate event occurs when a workbook is activated.
WorkbookEvents_AddinInstallEventHandlerA Delegate type used to add an event handler for the AddinInstall event. The AddinInstall event occurs when the workbook is installed as an add-in.
WorkbookEvents_AddinUninstallEventHandlerA Delegate type used to add an event handler for the AddinUninstall event. The AddinUninstall event occurs when the workbook is uninstalled as an add-in.
WorkbookEvents_AfterXmlExportEventHandlerA Delegate type used to add an event handler for the AfterXmlExport event. The AfterXmlExport event occurs after Microsoft Excel saves or exports data from the specified workbook to an XML data file.
WorkbookEvents_AfterXmlImportEventHandlerA Delegate type used to add an event handler for the AfterXmlImport event. The AfterXmlImport event occurs after an existing XML data connection is refreshed or after new XML data is imported into the specified Microsoft Excel workbook.
WorkbookEvents_BeforeCloseEventHandlerA Delegate type used to add an event handler for the BeforeClose event. The BeforeClose event occurs before the workbook closes. If the workbook has been changed, this event occurs before the user is asked to save changes.
WorkbookEvents_BeforePrintEventHandlerA Delegate type used to add an event handler for the BeforePrint event. The BeforePrint event occurs before the workbook (or anything in it) is printed.
WorkbookEvents_BeforeSaveEventHandlerA Delegate type used to add an event handler for the BeforeSave event. The BeforeSave event occurs before the workbook is saved.
WorkbookEvents_BeforeXmlExportEventHandlerA Delegate type used to add an event handler for the BeforeXmlExport event. The BeforeXmlExport event occurs before Microsoft Excel saves or exports data from the specified workbook to an XML data file.
WorkbookEvents_BeforeXmlImportEventHandlerA Delegate type used to add an event handler for the BeforeXmlImport event. The BeforeXmlImport event occurs before an existing XML data connection is refreshed or before new XML data is imported into a Microsoft Excel workbook.
WorkbookEvents_DeactivateEventHandlerA Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the workbook is deactivated.
WorkbookEvents_NewSheetEventHandlerA Delegate type used to add an event handler for the NewSheet event. The NewSheet event occurs when a new sheet is created in the workbook.
WorkbookEvents_OpenEventHandlerA Delegate type used to add an event handler for the Open event. The Open event occurs when the workbook is opened.
WorkbookEvents_PivotTableCloseConnectionEventHandlerA Delegate type used to add an event handler for the PivotTableCloseConnection event. The PivotTableCloseConnection event occurs after a PivotTable report closes the connection to its data source.
WorkbookEvents_PivotTableOpenConnectionEventHandlerA Delegate type used to add an event handler for the PivotTableOpenConnection event. The PivotTableOpenConnection event occurs after a PivotTable report opens the connection to its data source.
WorkbookEvents_SheetActivateEventHandlerA Delegate type used to add an event handler for the SheetActivate event. The SheetActivate event occurs when any sheet is activated.
WorkbookEvents_SheetBeforeDoubleClickEventHandlerA Delegate type used to add an event handler for the SheetBeforeDoubleClick event. The SheetBeforeDoubleClick event occurs when any worksheet is double-clicked, before the default double-click action.
WorkbookEvents_SheetBeforeRightClickEventHandlerA Delegate type used to add an event handler for the SheetBeforeRightClick event. The SheetBeforeRightClick event occurs when any worksheet is right-clicked, before the default right-click action.
WorkbookEvents_SheetCalculateEventHandlerA Delegate type used to add an event handler for the SheetCalculate event. The SheetCalculate event occurs after any worksheet is recalculated or after any changed data is plotted on a chart.
WorkbookEvents_SheetChangeEventHandlerA Delegate type used to add an event handler for the SheetChange event. The SheetChange event occurs when cells in any worksheet are changed by the user or by an external link.
WorkbookEvents_SheetDeactivateEventHandlerA Delegate type used to add an event handler for the SheetDeactivate event. The SheetDeactivate event occurs when any sheet is deactivated.
WorkbookEvents_SheetFollowHyperlinkEventHandlerA Delegate type used to add an event handler for the SheetFollowHyperlink event. The SheetFollowHyperlink event occurs when you click any hyperlink in Microsoft Excel.
WorkbookEvents_SheetPivotTableUpdateEventHandlerA Delegate type used to add an event handler for the SheetPivotTableUpdate event. The SheetPivotTableUpdate event occurs after the sheet of the PivotTable report has been updated.
WorkbookEvents_SheetSelectionChangeEventHandlerA Delegate type used to add an event handler for the SheetSelectionChange event. The SheetSelectionChange event occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet).
WorkbookEvents_SyncEventHandlerA Delegate type used to add an event handler for the Sync event. The Sync event occurs when the local copy of a worksheet that is part of a Document Workspace is synchronized with the copy on the server.
WorkbookEvents_WindowActivateEventHandlerA Delegate type used to add an event handler for the WindowActivate event. The WindowActivate event occurs when any workbook window is activated.
WorkbookEvents_WindowDeactivateEventHandlerA Delegate type used to add an event handler for the WindowDeactivate event. The WindowDeactivate event occurs when any workbook window is deactivated.
WorkbookEvents_WindowResizeEventHandlerA Delegate type used to add an event handler for the WindowResize event. The WindowResize event occurs when any workbook window is resized.

EnumerationDescription
ConstantsSpecifies global constants used in Microsoft Excel.
XlApplicationInternationalSpecifies country/region and international settings.
XlApplyNamesOrderSpecifies which range name is listed first when a cell reference is replaced by a row-oriented and column-oriented range name.
XlArabicModesSpecifies spelling rules for the Arabic spelling checker.
XlArrangeStyleSpecifies how windows are arranged on the screen.
XlArrowHeadLengthSpecifies the length of the arrowhead at the end of a line.
XlArrowHeadStyleSpecifies the type of arrowhead to apply to the line end.
XlArrowHeadWidthSpecifies the width of the arrowhead at the line end.
XlAutoFillTypeSpecifies how the target range is to be filled, based on the contents of the source range.
XlAutoFilterOperatorSpecifies the operator to use to associate two criteria applied by a filter.
XlAxisCrossesSpecifies the point on the specified axis where the other axis crosses.
XlAxisGroupSpecifies the type of axis group.
XlAxisTypeSpecifies the axis type.
XlBackgroundSpecifies the background type for text in charts.
XlBarShapeSpecifies the shape used with the 3-D bar or column chart.
XlBordersIndexSpecifies the border to be retrieved.
XlBorderWeightSpecifies the weight of the border around a range.
XlBuiltInDialogSpecifies which dialog box to display.
XlCalculatedMemberTypeSpecifies the type of a calculated member in a pivot table.
XlCalculationSpecifies the calculation mode.
XlCalculationInterruptKeySpecifies which key interrupts recalculation.
XlCalculationStateSpecifies the calculation state of the application.
XlCategoryTypeSpecifies the type of the category axis.
XlCellInsertionModeSpecifies the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a recordset returned by a query.
XlCellTypeSpecifies the type of cells.
XlChartGallerySpecifies a chart gallery.
XlChartItemSpecifies the type of the chart item.
XlChartLocationSpecifies where to relocate a chart.
XlChartPicturePlacementSpecifies the placement of a user-selected picture on a bar in a 3-D bar or column.
XlChartPictureTypeSpecifies how pictures are displayed on a column, bar picture chart, or legend key.
XlChartSplitTypeSpecifies the values displayed in the second chart in a pie chart or a bar of pie chart.
XlChartTypeSpecifies the chart type.
XlClipboardFormatSpecifies the format of an item on the Windows clipboard.
XlCmdTypeSpecifies the value of the CommandText property.
XlColorIndexSpecifies the color of a selected feature such as border, font, or fill.
XlColumnDataTypeSpecifies how a column is to be parsed.
XlCommandUnderlinesSpecifies the state of the command underlines in Microsoft Excel for the Macintosh.
XlCommentDisplayModeSpecifies the way cells display comments and comment indicators.
XlConsolidationFunctionSpecifies the subtotal function.
XlCopyPictureFormatSpecifies the format of the picture being copied.
XlCorruptLoadSpecifies the processing for a file when it is opened.
XlCreatorSpecifies the 32-bit creator code for Excel for Macintosh (decimal 1480803660, Hex 5843454C, string XCEL).
XlCubeFieldTypeSpecifies whether the OLAP field is a hierarchy, set, or measure field.
XlCutCopyModeSpecifies whether status is Copy mode or Cut mode.
XlCVErrorSpecifies the cell error number and value.
XlDataLabelPositionSpecifies where the data label is positioned.
XlDataLabelSeparatorSpecifies the separator used with data labels.
XlDataLabelsTypeSpecifies the type of data label to apply.
XlDataSeriesDateSpecifies the type of date to apply to a data series.
XlDataSeriesTypeSpecifies the data series to create.
XlDeleteShiftDirectionSpecifies how to shift cells to replace deleted cells.
XlDirectionSpecifies the direction in which to move.
XlDisplayBlanksAsSpecifies how blank cells are plotted on a chart.
XlDisplayDrawingObjectsSpecifies how shapes are displayed.
XlDisplayUnitSpecifies the display unit label for an axis.
XlDVAlertStyleSpecifies the icon used in message boxes displayed during validation.
XlDVTypeSpecifies the type of validation test to be performed in conjunction with values.
XlEditionFormatSpecifies the format of the published edition. This is Macintosh only and should not be used.
XlEditionOptionsOptionThis enumeration is for Macintosh only and should not be used.
XlEditionTypeSpecifies the type of edition to be changed.
XlEnableCancelKeySpecifies how Microsoft Excel handles CTRL+BREAK (or ESC or COMMAND+PERIOD) user interruptions to the running procedure.
XlEnableSelectionSpecifies what can be selected on the sheet.
XlEndStyleCapSpecifies the end style for error bars.
XlErrorBarDirectionSpecifies which axis values are to receive error bars.
XlErrorBarIncludeSpecifies which error bar parts to include.
XlErrorBarTypeSpecifies the range marked by error bars.
XlErrorChecksSpecifies the type of error object to be retrieved from the Errors collection.
XlFileAccessSpecifies the new access mode for the object.
XlFileFormatSpecifies the file format when saving the spreadsheet.
XlFillWithSpecifies how to copy the range.
XlFilterActionSpecifies whether data is to be copied or left in place during a filter operation.
XlFindLookInSpecifies the type of data to search.
XlFormatConditionOperatorSpecifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas.
XlFormatConditionTypeSpecifies whether the conditional format is based on a cell value or an expression.
XlFormControlSpecifies the type of the form control.
XlFormulaLabelSpecifies the formula label type for the specified range.
XlHAlignSpecifies the horizontal alignment for the object.
XlHebrewModesSpecifies the mode for the Hebrew spelling checker.
XlHighlightChangesTimeSpecifies which set of changes is shown in a shared workbook.
XlHtmlTypeSpecifies the type of HTML generated by Microsoft Excel when you save the specified item to a Web page and whether the item is static or interactive.
XlIMEModeSpecifies the description of the Japanese input rules.
XlImportDataAsSpecifies the format in which to return data from a database.
XlInsertFormatOriginSpecifies from where to copy the format for inserted rows.
XlInsertShiftDirectionSpecifies the direction in which to shift cells during an insertion.
XlLayoutFormTypeSpecifies the way the specified PivotTable items appear—in table format or in outline format.
XlLegendPositionSpecifies the position of the legend on a chart.
XlLineStyleSpecifies the line style for the border.
XlLinkSpecifies the type of link.
XlLinkInfoSpecifies the type of information to be returned.
XlLinkInfoTypeSpecifies the type of link.
XlLinkStatusSpecifies the status of a link.
XlLinkTypeSpecifies the type of link.
XlListConflictSpecifies the conflict resolution options for updating a list on a Microsoft Windows SharePoint Services site with the changes made to a list in a Microsoft Excel worksheet.
XlListDataTypeSpecifies the data type of a list column connected to a Microsoft Windows SharePoint Services site.
XlListObjectSourceTypeSpecifies the current source of the list.
XlLocationInTableSpecifies the part of the PivotTable report that contains the upper-left corner of a range.
XlLookAtSpecifies whether a match is made against the whole of the search text or any part of the search text.
XlMailSystemSpecifies the mail system that is installed on the host machine.
XlMarkerStyleSpecifies the marker style for a point or series in a line chart, scatter chart, or radar chart.
XlMouseButtonSpecifies which mouse button was pressed.
XlMousePointerSpecifies the appearance of the mouse pointer in Microsoft Excel.
XlMSApplicationSpecifies a Microsoft application.
XlObjectSizeSpecifies the way a chart is scaled to fit on a page.
XlOLETypeSpecifies the OLE object type.
XlOLEVerbSpecifies the verb that the server of the OLE object should act on.
XlOrderSpecifies the order in which cells are processed.
XlOrientationSpecifies the text orientation.
XlPageBreakSpecifies page break location in the worksheet.
XlPageBreakExtentSpecifies whether a page break is full screen or applies only within the print area.
XlPageOrientationSpecifies the page orientation when the worksheet is printed.
XlPaperSizeSpecifies the size of the paper.
XlParameterDataTypeSpecifies the data type of a query parameter.
XlParameterTypeSpecifies how to determine the value of the parameter for the specified query table.
XlPasteSpecialOperationSpecifies how numeric data will be calculated with the destinations cells in the worksheet.
XlPasteTypeSpecifies the part of the range to be pasted.
XlPatternSpecifies the interior pattern of a chart or interior object.
XlPhoneticAlignmentSpecifies the alignment for phonetic text.
XlPhoneticCharacterTypeSpecifies the type of phonetic text in a cell.
XlPictureAppearanceSpecifies how the picture should be copied.
XlPictureConvertorTypeSpecifies how to convert a graphic.
XlPivotCellTypeSpecifies the PivotTable entity the cell corresponds to.
XlPivotFieldCalculationSpecifies the type of calculation performed by a data PivotField when a custom calculation is used.
XlPivotFieldDataTypeSpecifies the type of data in the PivotTable field.
XlPivotFieldOrientationSpecifies the location of the field in a PivotTable report.
XlPivotFormatTypeSpecifies the type of report formatting to be applied to the specified PivotTable report.
XlPivotTableMissingItemsSpecifies the maximum number of unique items per PivotField allowed.
XlPivotTableSourceTypeSpecifies the source of the report data.
XlPivotTableVersionListSpecifies the Microsoft Excel version number.
XlPlacementSpecifies the way an object is attached to its underlying cells.
XlPlatformSpecifies the platform that a text file originated on.
XlPrintErrorsSpecifies the type of print error displayed.
XlPrintLocationSpecifies the way comments are printed with the sheet.
XlPrioritySpecifies the priority of a SendMailer message.
XlPTSelectionModeSpecifies what may be selected in a PivotTable during a structured selection. These constants may be combined to select multiple types.
XlQueryTypeSpecifies the type of query used by Microsoft Excel to populate the query table or PivotTable cache.
XlRangeAutoFormatSpecifies the predefined format when a range is automatically formatted.
XlRangeValueDataTypeSpecifies the range value data type.
XlReferenceStyleSpecifies the reference style.
XlReferenceTypeSpecifies cell reference style when a formula is being converted.
XlRobustConnectSpecifies how the PivotTable cache connects to its data source.
XlRoutingSlipDeliverySpecifies the routing delivery method.
XlRoutingSlipStatusSpecifies the status of the routing slip.
XlRowColSpecifies whether the values corresponding to a particular data series are in rows or columns.
XlRunAutoMacroSpecifies the automatic macro to run.
XlSaveActionSpecifies during file close if the file will be saved.
XlSaveAsAccessModeSpecifies the access mode for the Save As function.
XlSaveConflictResolutionSpecifies the way conflicts are to be resolved whenever a shared workbook is updated.
XlScaleTypeSpecifies the scale type of the value axis.
XlSearchDirectionSpecifies the search direction when searching a range.
XlSearchOrderSpecifies the order in which to search the range.
XlSearchWithinSpecifies the extent of the search for the range.
XlSheetTypeSpecifies the worksheet type.
XlSheetVisibilitySpecifies whether the object is visible.
XlSizeRepresentsSpecifies what the bubble size represents on a bubble chart.
XlSmartTagControlTypeSpecifies the type of Smart Document control displayed in the Document Actions task pane.
XlSmartTagDisplayModeSpecifies the display features for smart tags.
XlSortDataOptionSpecifies how to sort text.
XlSortMethodSpecifies the type of sort.
XlSortMethodOldSpecifies how to sort when using East Asian sorting methods.
XlSortOrderSpecifies the sort order for the specified field or range.
XlSortOrientationSpecifies the sort orientation.
XlSortTypeSpecifies which elements are to be sorted. Use this argument only when sorting PivotTable reports.
XlSourceTypeIdentifies the source object.
XlSpeakDirectionSpecifies the order in which the cells are spoken.
XlSpecialCellsValueSpecifies cells with a particular type of value to include in the result.
XlSubscribeToFormatSpecifies the format to use when subscribing to a published edition.
XlSubtototalLocationTypeSpecifies where the subtotal will be displayed on the worksheet.
XlSummaryColumnSpecifies the location of the summary columns in the outline.
XlSummaryReportTypeSpecifies the type of summary to be created for scenarios.
XlSummaryRowSpecifies the location of the summary rows in the outline.
XlTabPositionSpecifies the first or last tab position.
XlTextParsingTypeSpecifies the column format for the data in the text file that you’re importing into a query table.
XlTextQualifierSpecifies the delimiter to use to specify text.
XlTextVisualLayoutTypeSpecifies whether the visual layout of the text being imported is left-to-right or right-to-left.
XlTickLabelOrientationSpecifies the text orientation for tick-mark labels.
XlTickLabelPositionSpecifies the position of tick-mark labels on the specified axis.
XlTickMarkSpecifies the position of major and minor tick marks for an axis.
XlTimeUnitSpecifies unit of time for chart axis and data series.
XlToolbarProtectionSpecifies which properties of a toolbar are restricted. Options may be combined using Or.
XlTotalsCalculationSpecifies the type of calculation in the Totals row of a list column.
XlTrendlineTypeSpecifies how the trendline that smoothes out fluctuations in the data is calculated.
XlUnderlineStyleSpecifies the type of underline applied to a font.
XlUpdateLinksSpecifies a workbook's setting for updating embedded OLE links.
XlVAlignSpecifies the vertical alignment for the object.
XlWBATemplateSpecifies the type of workbook to create.
XlWebFormattingSpecifies how much formatting from a Web page, if any, is applied when a Web page is imported into a query table.
XlWebSelectionTypeSpecifies whether an entire Web page, all tables on the Web page, or only a specific table is imported into a query table.
XlWindowStateSpecifies the state of the window.
XlWindowTypeSpecifies how the chart is displayed.
XlWindowViewSpecifies the view showing in the window.
XlXLMMacroTypeSpecifies, in a Microsoft Excel version 4 macro worksheet, what type of macro a name refers to or whether the name refers to a macro.
XlXmlExportResultSpecifies the results of the save or export operation.
XlXmlImportResultSpecifies the results of the refresh or import operation.
XlXmlLoadOptionSpecifies how Excel opens the XML data file.
XlYesNoGuessSpecifies whether or not the first row contains headers.
Anzeigen:
© 2014 Microsoft