Workbooks Property

Microsoft Office Web Components Visual Basic

previous page next page

expression.Workbooks

expression Required. An expression that returns a Spreadsheet object.



  
  
    
      previous page
    

     start

    
       next page



				

                               
                                        
                                                
                                                        
                                                        
                                                                
                                                                        
                                                                                Menu
                                                                        
                                                                        
                                                                                Homepage
 
                                                                        
								
         Table of contents
        
  
    
      Microsoft Office Web Components Visual Basic Reference
      
        
          What's New
          
            
              New Objects
            
            
              New Properties (Alphabetic List)
            
            
              New Properties (by Object)
            
            
              New Methods (Alphabetic List)
            
            
              New Methods (by Object)
            
            
              New Events
            
          
        
        
          Programming Concepts
          
            
              Microsoft Office Chart Workspace Examples
            
            
              Declaring and Using Event Procedures in VBScript
            
            
              Using Named Constants in VBScript
            
            
              Making Secure Connections to External Data Sources
            
            
              Creating an Accessible Chart
            
          
        
        
          Collections
          
            
              A
              
                
                  AllGroupingDefs Collection
                
                
                  AllPageFields Collection
                
              
            
            
              B
              
                
                  Borders Collection
                
              
            
            
              C
              
                
                  ChAxes Collection
                
                
                  ChCategoryLabels Collection
                
                
                  ChChartFields Collection
                
                
                  ChCharts Collection
                
                
                  ChDataLabelsCollection Collection
                
                
                  ChErrorBarsCollection Collection
                
                
                  ChLegendEntries Collection
                
                
                  ChPoints Collection
                
                
                  ChSelectionCollection Collection
                
                
                  ChSeriesCollection Collection
                
                
                  ChTrendlines Collection
                
              
            
            
              D
              
                
                  DataPages Collection
                
              
            
            
              E
              
                
                  ElementExtensions Collection
                
              
            
            
              F
              
                
                  Filters Collection
                
              
            
            
              G
              
                
                  GroupingDefs Collection
                
                
                  GroupLevels Collection
                
              
            
            
              H
              
                
                  Headings Collection
                
              
            
            
              L
              
                
                  ListObjects Collection
                
                
                  ListRows Collection
                
                
                  LookupRelationships Collection
                
                
                  LookupSchemaRelationships Collection
                
              
            
            
              N
              
                
                  Names Collection
                
              
            
            
              O
              
                
                  OCCommands Collection
                
              
            
            
              P
              
                
                  PageFields Collection
                
                
                  PageRelatedFields Collection
                
                
                  PageRowsources Collection
                
                
                  Panes Collection
                
                
                  ParameterValues Collection
                
                
                  PivotAggregates Collection
                
                
                  PivotAxisMembers Collection
                
                
                  PivotColumnMembers Collection
                
                
                  PivotFields Collection
                
                
                  PivotFieldSets Collection
                
                
                  PivotMemberProperties Collection
                
                
                  PivotMembers Collection
                
                
                  PivotPageMembers Collection
                
                
                  PivotResultGroupFields Collection
                
                
                  PivotResultMemberProperties Collection
                
                
                  PivotRowMembers Collection
                
                
                  PivotTotals Collection
                
              
            
            
              R
              
                
                  RecordsetDefs Collection
                
              
            
            
              S
              
                
                  SchemaFields Collection
                
                
                  SchemaParameters Collection
                
                
                  SchemaRelationships Collection
                
                
                  SchemaRowsources Collection
                
                
                  Sheets Collection
                
                
                  SublistRelationships Collection
                
                
                  SublistSchemaRelationships Collection
                
              
            
            
              W
              
                
                  Windows Collection
                
                
                  Workbooks Collection
                
                
                  Worksheets Collection
                
              
            
            
              X
              
                
                  XmlDataBindings Collection
                
                
                  XmlMaps Collection
                
              
            
          
        
        
          Objects
          
            
              A
              
                
                  AutoFilter Object
                
              
            
            
              B
              
                
                  Border Object
                
                
                  ByRef Object
                
              
            
            
              C
              
                
                  ChartSpace Object
                
                
                  ChAxis Object
                
                
                  ChBorder Object
                
                
                  ChCategoryLabel Object
                
                
                  ChChart Object
                
                
                  ChChartDraw Object
                
                
                  ChChartField Object
                
                
                  ChChartSpace Object
                
                
                  ChDataLabel Object
                
                
                  ChDataLabels Object
                
                
                  ChDropZone Object
                
                
                  ChErrorBars Object
                
                
                  ChFont Object
                
                
                  ChFormatMap Object
                
                
                  ChGridlines Object
                
                
                  ChInterior Object
                
                
                  ChLegend Object
                
                
                  ChLegendEntry Object
                
                
                  ChLine Object
                
                
                  ChMarker Object
                
                
                  ChPlotArea Object
                
                
                  ChPoint Object
                
                
                  ChScaling Object
                
                
                  ChScrollView Object
                
                
                  ChSegment Object
                
                
                  ChSegmentBoundary Object
                
                
                  ChSegments Object
                
                
                  ChSeries Object
                
                
                  ChSurface Object
                
                
                  ChTitle Object
                
                
                  ChTrendline Object
                
                
                  ChUserDefinedSelection Object
                
                
                  Coordinate Object
                
                
                  Criteria Object
                
              
            
            
              D
              
                
                  DataPage Object
                
                
                  DataSourceControl Object
                
                
                  DSCEventInfo Object
                
              
            
            
              E
              
                
                  ElementExtension Object
                
                
                  ExpandControl Object
                
              
            
            
              F
              
                
                  Filter Object
                
                
                  Font Object
                
              
            
            
              G
              
                
                  GroupingDef Object
                
                
                  GroupLevel Object
                
              
            
            
              H
              
                
                  Heading Object
                
                
                  Hyperlink Object
                
              
            
            
              I
              
                
                  Interior Object
                
              
            
            
              L
              
                
                  ListObject Object
                
                
                  ListRow Object
                
              
            
            
              N
              
                
                  Name Object
                
              
            
            
              O
              
                
                  OCCommand Object
                
                
                  OfflineInfo Object
                
                
                  OWCLanguageSettings Object
                
              
            
            
              P
              
                
                  PageField Object
                
                
                  PageRelatedField Object
                
                
                  PageRelationship Object
                
                
                  PageRowsource Object
                
                
                  Pane Object
                
                
                  ParameterValue Object
                
                
                  PivotAggregate Object
                
                
                  PivotAxis Object
                
                
                  PivotAxisMember Object
                
                
                  PivotCell Object
                
                
                  PivotColumnMember Object
                
                
                  PivotData Object
                
                
                  PivotDataAxis Object
                
                
                  PivotDetailCell Object
                
                
                  PivotDetailRange Object
                
                
                  PivotField Object
                
                
                  PivotFieldSet Object
                
                
                  PivotFilterAxis Object
                
                
                  PivotFont Object
                
                
                  PivotGroupAxis Object
                
                
                  PivotHyperlink Object
                
                
                  PivotLabel Object
                
                
                  PivotMember Object
                
                
                  PivotMemberProperty Object
                
                
                  PivotPageMember Object
                
                
                  PivotRange Object
                
                
                  PivotResultAxis Object
                
                
                  PivotResultColumnAxis Object
                
                
                  PivotResultDataAxis Object
                
                
                  PivotResultField Object
                
                
                  PivotResultFilterAxis Object
                
                
                  PivotResultGroupAxis Object
                
                
                  PivotResultGroupField Object
                
                
                  PivotResultLabel Object
                
                
                  PivotResultMemberProperty Object
                
                
                  PivotResultPageAxis Object
                
                
                  PivotResultRowAxis Object
                
                
                  PivotRowMember Object
                
                
                  PivotTable Object
                
                
                  PivotTotal Object
                
                
                  PivotView Object
                
                
                  Protection Object
                
              
            
            
              R
              
                
                  Range Object
                
                
                  RecordNavigationControl Object
                
                
                  RecordsetDef Object
                
              
            
            
              S
              
                
                  SchemaField Object
                
                
                  SchemaParameter Object
                
                
                  SchemaProperties Object
                
                
                  SchemaProperty Object
                
                
                  SchemaRelatedField Object
                
                
                  SchemaRelatedFields Object
                
                
                  SchemaRelationship Object
                
                
                  SchemaRowsource Object
                
                
                  Section Object
                
                
                  Spreadsheet Object
                
              
            
            
              T
              
                
                  TitleBar Object
                
              
            
            
              W
              
                
                  Window Object
                
                
                  Workbook Object
                
                
                  Worksheet Object
                
              
            
            
              X
              
                
                  XmlDataBinding Object
                
                
                  XmlMap Object
                
              
            
          
        
        
          Methods
          
            
              A
              
                
                  Activate Method
                
                
                  Add Method
                
                
                  AddCalculatedField Method
                
                
                  AddCalculatedTotal Method
                
                
                  AddCustomGroupField Method
                
                
                  AddCustomGroupMember Method
                
                
                  AddFieldSet Method
                
                
                  AddIn Method
                
                
                  AddNew Method
                
                
                  AddTotal Method
                
                
                  Apply Method
                
                
                  ApplyFilter Method
                
                
                  AutoFilter Method
                
                
                  AutoFit Method
                
                
                  AutoLayout Method
                
              
            
            
              B
              
                
                  BeginObject Method
                
                
                  BeginUndo Method
                
                
                  BorderAround Method
                
              
            
            
              C
              
                
                  Calculate Method
                
                
                  CalculateFull Method
                
                
                  Clear Method
                
                
                  ClearContents Method
                
                
                  ClearFormats Method
                
                
                  Collapse Method
                
                
                  Copy Method
                
                
                  CopyFromRecordset Method
                
                
                  Cut Method
                
              
            
            
              D
              
                
                  Delete Method
                
                
                  DeleteCustomGroupMember Method
                
                
                  DeleteField Method
                
                
                  DeleteFieldSet Method
                
                
                  DeleteRecord Method
                
                
                  DeleteTotal Method
                
                
                  DrawEllipse Method
                
                
                  DrawLine Method
                
                
                  DrawPolygon Method
                
                
                  DrawPolyLine Method
                
                
                  DrawRectangle Method
                
                
                  DrawText Method
                
                
                  DropZones Method
                
                
                  DuplicateFormat Method
                
              
            
            
              E
              
                
                  EndEdit Method
                
                
                  EndObject Method
                
                
                  EndUndo Method
                
                
                  EuroConvert Method
                
                
                  Evaluate Method
                
                
                  Execute Method
                
                
                  Expand Method
                
                
                  Export Method
                
                
                  ExportMetaData Method
                
                
                  ExportPicture Method
                
                
                  ExportXML Method
                
              
            
            
              F
              
                
                  FillDown Method
                
                
                  FillRight Method
                
                
                  Find Method
                
                
                  FindNext Method
                
                
                  FindPrevious Method
                
                
                  FireParametersOut Method
                
                
                  FlipHorizontal Method
                
                
                  FlipVertical Method
                
                
                  Follow Method
                
              
            
            
              G
              
                
                  GetContainingSection Method
                
                
                  GetDataPointVisible Method
                
                
                  GetPicture Method
                
                
                  GetValue Method
                
                
                  Group Method
                
              
            
            
              H
              
                
                  HideDetails Method
                
              
            
            
              I
              
                
                  ImportXml Method
                
                
                  Insert Method
                
                
                  InsertFieldSet Method
                
                
                  InsertTotal Method
                
                
                  IsButtonEnabled Method
                
                
                  Item Method
                
              
            
            
              L
              
                
                  LargeScroll Method
                
                
                  Load Method
                
                
                  LoadText Method
                
              
            
            
              M
              
                
                  MakeCurrent Method
                
                
                  Merge Method
                
                
                  Move Method
                
                
                  MoveDetailLeft Method
                
                
                  MoveDetailTop Method
                
                
                  MoveFirst Method
                
                
                  MoveLast Method
                
                
                  MoveLeft Method
                
                
                  MoveNext Method
                
                
                  MovePrevious Method
                
                
                  MoveTop Method
                
              
            
            
              N
              
                
                  NewRecord Method
                
                
                  Nz Method
                
              
            
            
              O
              
                
                  OverrideDefaultElementFormatting Method
                
              
            
            
              P
              
                
                  ParseText Method
                
                
                  Paste Method
                
                
                  PointsToScreenPixelsX Method
                
                
                  PointsToScreenPixelsY Method
                
                
                  Protect Method
                
              
            
            
              R
              
                
                  RangeFromPoint Method
                
                
                  RectIntersect Method
                
                
                  RectUnion Method
                
                
                  Refresh Method
                
                
                  RefreshJetCache Method
                
                
                  RemoveFieldSet Method
                
                
                  RemoveTotal Method
                
                
                  Repaint Method
                
                
                  Requery Method
                
                
                  Reset Method
                
                
                  ResetColors Method
                
                
                  ResetHeadings Method
                
                
                  RotateClockwise Method
                
                
                  RotateCounterClockwise Method
                
              
            
            
              S
              
                
                  Save Method
                
                
                  ScrollIntoView Method
                
                
                  Select Method
                
                
                  Select2 Method
                
                
                  SetData Method
                
                
                  SetExtent Method
                
                
                  SetOneColorGradient Method
                
                
                  SetPatterned Method
                
                
                  SetPosition Method
                
                
                  SetPresetGradient Method
                
                
                  SetRootRecordset Method
                
                
                  SetSolid Method
                
                
                  SetSpreadsheetData Method
                
                
                  SetTextured Method
                
                
                  SetTwoColorGradient Method
                
                
                  Show Method
                
                
                  ShowAbout Method
                
                
                  ShowAllData Method
                
                
                  ShowContextMenu Method
                
                
                  ShowDetails Method
                
                
                  ShowHelp Method
                
                
                  SmallScroll Method
                
                
                  Sort Method
                
                
                  SortAscending Method
                
                
                  SortDescending Method
                
                
                  StartEdit Method
                
              
            
            
              T
              
                
                  TextHeight Method
                
                
                  TextWidth Method
                
                
                  ToggleFilter Method
                
              
            
            
              U
              
                
                  Undo Method
                
                
                  Ungroup Method
                
                
                  UnMerge Method
                
                
                  Unprotect Method
                
                
                  Update Method
                
                
                  UpdatePropertyToolbox Method
                
              
            
            
              V
              
                
                  Validate Method
                
                
                  ValueToPoint Method
                
              
            
          
        
        
          Properties
          
            
              A
              
                
                  Active Property
                
                
                  ActiveCell Property
                
                
                  ActiveData Property
                
                
                  ActiveObject Property
                
                
                  ActivePane Property
                
                
                  ActiveSheet Property
                
                
                  ActiveView Property
                
                
                  ActiveWindow Property
                
                
                  ActiveWorkbook Property
                
                
                  Address Property
                
                
                  Aggregates Property
                
                
                  AllGroupingDefs Property
                
                
                  AllIncludeExclude Property
                
                
                  AllMember Property
                
                
                  AllowAdditions Property
                
                
                  AllowCustomOrdering Property
                
                
                  AllowDeletingColumns Property
                
                
                  AllowDeletingRows Property
                
                
                  AllowDeletions Property
                
                
                  AllowDetails Property
                
                
                  AllowEdits Property
                
                
                  AllowFiltering Property
                
                
                  AllowFormattingColumns Property
                
                
                  AllowFormattingRows Property
                
                
                  AllowGrouping Property
                
                
                  AllowHeadingRename Property
                
                
                  AllowInsertingColumns Property
                
                
                  AllowInsertingRows Property
                
                
                  AllowLayoutEvents Property
                
                
                  AllowMultiFilter Property
                
                
                  AllowPointRenderEvents Property
                
                
                  AllowPropertyToolbox Property
                
                
                  AllowRenderEvents Property
                
                
                  AllowScreenTipEvents Property
                
                
                  AllowSorting Property
                
                
                  AllowUISelection Property
                
                
                  AllPageFields Property
                
                
                  AlternateDataSource Property
                
                
                  AlternateRowColor Property
                
                
                  AlwaysIncludeInCube Property
                
                
                  AmbientLightIntensity Property
                
                
                  Amount Property
                
                
                  Application Property
                
                
                  AspectRatio Property
                
                
                  Async Property
                
                
                  AutoFilter Property
                
                
                  AutoFilterMode Property
                
                
                  AutoFit Property
                
                
                  Axes Property
                
                
                  Axis Property
                
              
            
            
              B
              
                
                  BackColor Property
                
                
                  BackWall Property
                
                
                  BarWidth Property
                
                
                  BaseName Property
                
                
                  Begin Property
                
                
                  BindingData Property
                
                
                  BindingInProgress Property
                
                
                  Bold Property
                
                
                  Bookmark Property
                
                
                  Border Property
                
                
                  Borders Property
                
                
                  Bottom Property
                
                
                  BottomRight Property
                
                
                  BoundField Property
                
                
                  BubbleScale Property
                
                
                  Build Property
                
                
                  BuildNumber Property
                
                
                  ButtonBorder Property
                
                
                  ButtonFont Property
                
                
                  ButtonInterior Property
                
              
            
            
              C
              
                
                  Calculation Property
                
                
                  CalculationVersion Property
                
                
                  CanQuery Property
                
                
                  CanUndo Property
                
                
                  CanUpdate Property
                
                
                  Caption Property
                
                
                  CaptionHAlignment Property
                
                
                  CaptionSection Property
                
                
                  CategoryLabels Property
                
                
                  Cell Property
                
                
                  Cells Property
                
                
                  CellsEx Property
                
                
                  ChartDepth Property
                
                
                  ChartFields Property
                
                
                  ChartLayout Property
                
                
                  Charts Property
                
                
                  ChartSpaceLegend Property
                
                
                  ChartSpaceTitle Property
                
                
                  ChartWrapCount Property
                
                
                  Checked Property
                
                
                  ChildAxisMembers Property
                
                
                  ChildColumnMembers Property
                
                
                  ChildLabel Property
                
                
                  ChildMembers Property
                
                
                  ChildPageMembers Property
                
                
                  ChildRowMembers Property
                
                
                  ChildSection Property
                
                
                  Color Property
                
                
                  ColorIndex Property
                
                
                  Colors Property
                
                
                  Column Property
                
                
                  ColumnAxis Property
                
                
                  ColumnHeadings Property
                
                
                  ColumnMember Property
                
                
                  ColumnMembers Property
                
                
                  Columns Property
                
                
                  ColumnWidth Property
                
                
                  Commands Property
                
                
                  CommandText Property
                
                
                  CompareMemberCaptionsBy Property
                
                
                  CompareOrderedMembersBy Property
                
                
                  Connection Property
                
                
                  ConnectionFile Property
                
                
                  ConnectionString Property
                
                
                  Constants Property
                
                
                  ConsumesRecordset Property
                
                
                  Control Property
                
                
                  ControlSource Property
                
                
                  Count Property
                
                
                  Criteria Property
                
                
                  Crosses Property
                
                
                  CrossesAtValue Property
                
                
                  CrossingAxis Property
                
                
                  CSVData Property
                
                
                  CSVURL Property
                
                
                  CurrentArray Property
                
                
                  CurrentCell Property
                
                
                  CurrentRegion Property
                
                
                  CurrentSection Property
                
                
                  CustomGroupMembers Property
                
                
                  CustomGroupType Property
                
              
            
            
              D
              
                
                  DashStyle Property
                
                
                  Data Property
                
                
                  DataAxis Property
                
                
                  DataBodyRange Property
                
                
                  DataEntry Property
                
                
                  DataField Property
                
                
                  DataLabel Property
                
                
                  DataLabelsCollection Property
                
                
                  DataMember Property
                
                
                  DataPage Property
                
                
                  DataPages Property
                
                
                  DataPageSize Property
                
                
                  DataSource Property
                
                
                  DataSourceName Property
                
                
                  DataSourceType Property
                
                
                  DataType Property
                
                
                  DefaultColor Property
                
                
                  DefaultControlType Property
                
                
                  DefaultMember Property
                
                
                  DefaultQueryOnLoad Property
                
                
                  DefaultRecordset Property
                
                
                  DefaultSort Property
                
                
                  DefaultValue Property
                
                
                  DesignMode Property
                
                
                  DetailAutoFit Property
                
                
                  DetailBackColor Property
                
                
                  DetailCells Property
                
                
                  DetailColumnCount Property
                
                
                  DetailFont Property
                
                
                  DetailForeColor Property
                
                
                  DetailHAlignment Property
                
                
                  DetailLeft Property
                
                
                  DetailLeftOffset Property
                
                
                  DetailMaxHeight Property
                
                
                  DetailMaxWidth Property
                
                
                  DetailRange Property
                
                
                  DetailRowCount Property
                
                
                  DetailRowHeight Property
                
                
                  DetailsExpanded Property
                
                
                  DetailSortOrder Property
                
                
                  DetailTop Property
                
                
                  DetailTopOffset Property
                
                
                  DetailWidth Property
                
                
                  Direction Property
                
                
                  DirectionalLightInclination Property
                
                
                  DirectionalLightIntensity Property
                
                
                  DirectionalLightRotation Property
                
                
                  Dirty Property
                
                
                  DisplayAlert Property
                
                
                  DisplayAlerts Property
                
                
                  DisplayCalculatedMembers Property
                
                
                  DisplayColumnHeadings Property
                
                
                  DisplayCustomHeadings Property
                
                
                  DisplayDesignTimeUI Property
                
                
                  DisplayEmptyMembers Property
                
                
                  DisplayExpandIndicator Property
                
                
                  DisplayFieldButtons Property
                
                
                  DisplayFieldList Property
                
                
                  DisplayGridlines Property
                
                
                  DisplayHeadings Property
                
                
                  DisplayHorizontalScrollBar Property
                
                
                  DisplayIn Property
                
                
                  DisplayInFieldList Property
                
                
                  DisplayOfficeLogo Property
                
                
                  DisplayPropertyToolbox Property
                
                
                  DisplayRowHeadings Property
                
                
                  DisplayScreenTips Property
                
                
                  DisplayTitleBar Property
                
                
                  DisplayToolbar Property
                
                
                  DisplayTotal Property
                
                
                  DisplayVerticalScrollBar Property
                
                
                  DisplayWorkbookTabs Property
                
                
                  DisplayZeros Property
                
                
                  Divisions Property
                
                
                  DrawType Property
                
              
            
            
              E
              
                
                  EditMode Property
                
                
                  ElementExtensions Property
                
                
                  ElementID Property
                
                
                  EnableAutoFilter Property
                
                
                  Enabled Property
                
                
                  EnableEvents Property
                
                
                  EnableResize Property
                
                
                  EnableUndo Property
                
                
                  End Property
                
                
                  EndStyle Property
                
                
                  EntireColumn Property
                
                
                  EntireRow Property
                
                
                  Error Property
                
                
                  ErrorBarsCollection Property
                
                
                  ExcludedMembers Property
                
                
                  ExpandDetails Property
                
                
                  Expanded Property
                
                
                  ExpandedByDefault Property
                
                
                  ExpandMembers Property
                
                
                  Explosion Property
                
                
                  Expression Property
                
                
                  ExtrudeAngle Property
                
              
            
            
              F
              
                
                  Field Property
                
                
                  FieldLabelBackColor Property
                
                
                  FieldLabelFont Property
                
                
                  FieldLabelForeColor Property
                
                
                  FieldLabelHeight Property
                
                
                  Fields Property
                
                
                  FieldSet Property
                
                
                  FieldSets Property
                
                
                  FieldType Property
                
                
                  FillType Property
                
                
                  Filter Property
                
                
                  FilterAxis Property
                
                
                  FilterCaption Property
                
                
                  FilterContext Property
                
                
                  FilterCrossJoins Property
                
                
                  FilterFunction Property
                
                
                  FilterFunctionValue Property
                
                
                  FilterMode Property
                
                
                  FilterOn Property
                
                
                  FilterOnScope Property
                
                
                  Filters Property
                
                
                  FindAxisMember Property
                
                
                  FindColumnMember Property
                
                
                  FindMember Property
                
                
                  FindPageMember Property
                
                
                  FindRowMember Property
                
                
                  FirstSection Property
                
                
                  FirstSliceAngle Property
                
                
                  Floor Property
                
                
                  Font Property
                
                
                  FontName Property
                
                
                  ForeColor Property
                
                
                  Format Property
                
                
                  FormatMap Property
                
                
                  Formula Property
                
                
                  FormulaArray Property
                
                
                  FormulaLocal Property
                
                
                  FreezePanes Property
                
                
                  Function Property
                
              
            
            
              G
              
                
                  GapDepth Property
                
                
                  GapWidth Property
                
                
                  GradientDegree Property
                
                
                  GradientStyle Property
                
                
                  GradientVariant Property
                
                
                  GridlineColor Property
                
                
                  GridlineColorIndex Property
                
                
                  GridX Property
                
                
                  GridY Property
                
                
                  GroupedAutoFit Property
                
                
                  GroupedBackColor Property
                
                
                  GroupedFont Property
                
                
                  GroupedForeColor Property
                
                
                  GroupedHAlignment Property
                
                
                  GroupedHeight Property
                
                
                  GroupedWidth Property
                
                
                  GroupEnd Property
                
                
                  GroupField Property
                
                
                  GroupFields Property
                
                
                  GroupFilterControl Property
                
                
                  GroupFilterField Property
                
                
                  GroupFooter Property
                
                
                  GroupHeader Property
                
                
                  GroupingDefs Property
                
                
                  GroupingTotalFunction Property
                
                
                  GroupingType Property
                
                
                  GroupingUnit Property
                
                
                  GroupingUnitType Property
                
                
                  GroupInterval Property
                
                
                  GroupLevel Property
                
                
                  GroupLevels Property
                
                
                  GroupOn Property
                
                
                  GroupStart Property
                
              
            
            
              H
              
                
                  HAlignment Property
                
                
                  HasAbsoluteLabels Property
                
                
                  HasArray Property
                
                
                  HasAutoAspectRatio Property
                
                
                  HasAutoCaption Property
                
                
                  HasAutoChartDepth Property
                
                
                  HasAutoDivisions Property
                
                
                  HasAutoMajorUnit Property
                
                
                  HasAutoMaximum Property
                
                
                  HasAutoMinimum Property
                
                
                  HasAutoMinorUnit Property
                
                
                  HasBubbleSize Property
                
                
                  HasCategoryName Property
                
                
                  HasChartSpaceLegend Property
                
                
                  HasChartSpaceTitle Property
                
                
                  HasDetails Property
                
                
                  HasDiscreteDivisions Property
                
                
                  HasFormula Property
                
                
                  HasLegend Property
                
                
                  HasMajorGridlines Property
                
                
                  HasMinorGridlines Property
                
                
                  HasMultipleCharts Property
                
                
                  HasPassiveAlerts Property
                
                
                  HasPercentage Property
                
                
                  HasPlotDetails Property
                
                
                  HasRuntimeSelection Property
                
                
                  HasSelectionMarks Property
                
                
                  HasSeriesByRows Property
                
                
                  HasSeriesName Property
                
                
                  HasSplit Property
                
                
                  HasTickLabels Property
                
                
                  HasTitle Property
                
                
                  HasUnifiedScales Property
                
                
                  HasValue Property
                
                
                  HeaderBackColor Property
                
                
                  HeaderFont Property
                
                
                  HeaderForeColor Property
                
                
                  HeaderHAlignment Property
                
                
                  HeaderHeight Property
                
                
                  HeaderRowRange Property
                
                
                  Height Property
                
                
                  HeightRatio Property
                
                
                  Hidden Property
                
                
                  HoleSize Property
                
                
                  HorizontalAlignment Property
                
                
                  HorizontalExtent Property
                
                
                  HorizontalExtentMax Property
                
                
                  HorizontalPosition Property
                
                
                  HTMLContainer Property
                
                
                  HTMLData Property
                
                
                  HTMLURL Property
                
                
                  Hwnd Property
                
                
                  Hyperlink Property
                
              
            
            
              I
              
                
                  id Property
                
                
                  Inclination Property
                
                
                  Include Property
                
                
                  IncludedMembers Property
                
                
                  Index Property
                
                
                  InsertRowRange Property
                
                
                  Interior Property
                
                
                  InternalPivotTable Property
                
                
                  International Property
                
                
                  IsConsistent Property
                
                
                  IsDataBound Property
                
                
                  IsDirty Property
                
                
                  IsDisplayingEquation Property
                
                
                  IsDisplayingRSquared Property
                
                
                  IsExpanded Property
                
                
                  IsFiltered Property
                
                
                  IsFilterOn Property
                
                
                  IsHyperlink Property
                
                
                  IsIncluded Property
                
                
                  IsTotal Property
                
                
                  IsValid Property
                
                
                  Italic Property
                
                
                  Item Property
                
                
                  ItemCount Property
                
              
            
            
              J
              
                
                  JoinType Property
                
              
            
            
              L
              
                
                  Label Property
                
                
                  LanguageID Property
                
                
                  LanguagePreferredForEditing Property
                
                
                  LanguageSettings Property
                
                
                  Left Property
                
                
                  Left2 Property
                
                
                  LeftOffset Property
                
                
                  Legend Property
                
                
                  LegendEntries Property
                
                
                  Length Property
                
                
                  Level Property
                
                
                  LevelCount Property
                
                
                  LightNormal Property
                
                
                  Line Property
                
                
                  LineStyle Property
                
                
                  ListBoundField Property
                
                
                  ListDisplayField Property
                
                
                  ListObject Property
                
                
                  ListObjects Property
                
                
                  ListRows Property
                
                
                  ListRowSource Property
                
                
                  LoadMode Property
                
                
                  Location Property
                
                
                  Locked Property
                
                
                  LogBase Property
                
                
                  LookupRelationships Property
                
                
                  LookupSchemaRelationships Property
                
              
            
            
              M
              
                
                  MajorGridlines Property
                
                
                  MajorTickMarks Property
                
                
                  MajorUnit Property
                
                
                  MajorVersion Property
                
                
                  ManySide Property
                
                
                  MapData Property
                
                
                  Marker Property
                
                
                  MaxHeight Property
                
                
                  Maximum Property
                
                
                  MaxRecords Property
                
                
                  MaxWidth Property
                
                
                  Member Property
                
                
                  MemberCaptions Property
                
                
                  MemberProperties Property
                
                
                  MemberPropertiesOrder Property
                
                
                  MemberProperty Property
                
                
                  MergeArea Property
                
                
                  MergeCells Property
                
                
                  Minimum Property
                
                
                  MinorGridlines Property
                
                
                  MinorTickMarks Property
                
                
                  MinorUnit Property
                
                
                  MinorVersion Property
                
                
                  Miter Property
                
                
                  MoveAfterReturn Property
                
                
                  MoveAfterReturnDirection Property
                
              
            
            
              N
              
                
                  Name Property
                
                
                  Names Property
                
                
                  Next Property
                
                
                  NextSection Property
                
                
                  NextSibling Property
                
                
                  NumberFormat Property
                
                
                  NumericScale Property
                
              
            
            
              O
              
                
                  ObjectType Property
                
                
                  Offline Property
                
                
                  OfflinePublication Property
                
                
                  OfflineSource Property
                
                
                  OfflineType Property
                
                
                  Offset Property
                
                
                  OneSide Property
                
                
                  Order Property
                
                
                  OrderedMembers Property
                
                
                  Orientation Property
                
                
                  Overlap Property
                
              
            
            
              P
              
                
                  PageAxis Property
                
                
                  PageFields Property
                
                
                  PageMember Property
                
                
                  PageRelatedFields Property
                
                
                  PageRowsource Property
                
                
                  PageRowsources Property
                
                
                  Panes Property
                
                
                  ParameterValues Property
                
                
                  Parent Property
                
                
                  ParentAxisMember Property
                
                
                  ParentColumnMember Property
                
                
                  ParentLabel Property
                
                
                  ParentMember Property
                
                
                  ParentPageMember Property
                
                
                  ParentRecordsetDef Property
                
                
                  ParentRowMember Property
                
                
                  ParentSection Property
                
                
                  Path Property
                
                
                  Pattern Property
                
                
                  PercentComplete Property
                
                
                  Period Property
                
                
                  Perspective Property
                
                
                  PivotAxis Property
                
                
                  PivotObject Property
                
                
                  PlotAllAggregates Property
                
                
                  PlotArea Property
                
                
                  Points Property
                
                
                  Position Property
                
                
                  Precision Property
                
                
                  PrefixCharacter Property
                
                
                  PresetGradientType Property
                
                
                  PresetTexture Property
                
                
                  Previous Property
                
                
                  PreviousSection Property
                
                
                  PreviousSibling Property
                
                
                  PrimaryPageRowsource Property
                
                
                  PrintQuality3D Property
                
                
                  ProjectionMode Property
                
                
                  PropertyCaptionFont Property
                
                
                  PropertyCaptionHAlignment Property
                
                
                  PropertyCaptionWidth Property
                
                
                  PropertyHeight Property
                
                
                  PropertyValueFont Property
                
                
                  PropertyValueHAlignment Property
                
                
                  PropertyValueWidth Property
                
                
                  PropNames Property
                
                
                  ProtectContents Property
                
                
                  Protection Property
                
                
                  ProtectionMode Property
                
                
                  ProtectStructure Property
                
                
                  ProviderFormattedValue Property
                
                
                  ProviderType Property
                
              
            
            
              R
              
                
                  Range Property
                
                
                  RangeSelection Property
                
                
                  ReadingOrder Property
                
                
                  RecordNavigationSection Property
                
                
                  RecordSelector Property
                
                
                  Recordset Property
                
                
                  RecordsetDef Property
                
                
                  RecordsetDefs Property
                
                
                  RecordsetLabel Property
                
                
                  RecordsetType Property
                
                
                  RecordSource Property
                
                
                  RefersTo Property
                
                
                  RefersToLocal Property
                
                
                  RefersToRange Property
                
                
                  ResyncCommand Property
                
                
                  ReturnValue Property
                
                
                  RevisionNumber Property
                
                
                  Right Property
                
                
                  RightToLeft Property
                
                
                  Rotation Property
                
                
                  Row Property
                
                
                  RowAxis Property
                
                
                  RowHeadings Property
                
                
                  RowHeight Property
                
                
                  RowMember Property
                
                
                  RowMembers Property
                
                
                  Rows Property
                
              
            
            
              S
              
                
                  Scaling Property
                
                
                  Scalings Property
                
                
                  SchemaFields Property
                
                
                  SchemaParameters Property
                
                
                  SchemaRelatedFields Property
                
                
                  SchemaRelationships Property
                
                
                  SchemaRowsources Property
                
                
                  ScreenUpdating Property
                
                
                  ScrollColumn Property
                
                
                  ScrollRow Property
                
                
                  ScrollView Property
                
                
                  Section Property
                
                
                  Segments Property
                
                
                  SelectedSheets Property
                
                
                  Selection Property
                
                
                  SelectionCollection Property
                
                
                  SelectionType Property
                
                
                  Separator Property
                
                
                  SeriesCollection Property
                
                
                  ServerFilter Property
                
                
                  Sheets Property
                
                
                  ShowAll Property
                
                
                  ShowAs Property
                
                
                  ShowAsValue Property
                
                
                  ShowDelButton Property
                
                
                  ShowFilterBySelectionButton Property
                
                
                  ShowFirstButton Property
                
                
                  ShowHelpButton Property
                
                
                  ShowLabel Property
                
                
                  ShowLastButton Property
                
                
                  ShowNewButton Property
                
                
                  ShowNextButton Property
                
                
                  ShowPrevButton Property
                
                
                  ShowSaveButton Property
                
                
                  ShowSortAscendingButton Property
                
                
                  ShowSortDescendingButton Property
                
                
                  ShowToggleFilterButton Property
                
                
                  ShowUndoButton Property
                
                
                  SideWall Property
                
                
                  Size Property
                
                
                  SizeRepresents Property
                
                
                  SolveOrder Property
                
                
                  SortDirection Property
                
                
                  SortOn Property
                
                
                  SortOnScope Property
                
                
                  Source Property
                
                
                  SourceAxis Property
                
                
                  SourceColumnAxis Property
                
                
                  SourceDataAxis Property
                
                
                  SourceField Property
                
                
                  SourceFilterAxis Property
                
                
                  SourceLabel Property
                
                
                  SourceMember Property
                
                
                  SourcePageAxis Property
                
                
                  SourceRowAxis Property
                
                
                  SplitMaximum Property
                
                
                  SplitMinimum Property
                
                
                  StandardHeight Property
                
                
                  StandardWidth Property
                
                
                  Status Property
                
                
                  Style Property
                
                
                  SubAddress Property
                
                
                  SublistRelationships Property
                
                
                  SublistSchemaRelationships Property
                
                
                  SubtotalBackColor Property
                
                
                  SubtotalFont Property
                
                
                  SubtotalForeColor Property
                
                
                  SubtotalLabelBackColor Property
                
                
                  SubtotalLabelFont Property
                
                
                  SubtotalLabelForeColor Property
                
                
                  SubtotalLabelHAlignment Property
                
                
                  Subtotals Property
                
              
            
            
              T
              
                
                  TabRatio Property
                
                
                  Text Property
                
                
                  TextureFormat Property
                
                
                  TextureName Property
                
                
                  TexturePlacement Property
                
                
                  TextureStackUnit Property
                
                
                  Thickness Property
                
                
                  TickLabelSpacing Property
                
                
                  TickLabelUnitType Property
                
                
                  TickMarkSpacing Property
                
                
                  TickMarkUnitType Property
                
                
                  TimeValue Property
                
                
                  TipText Property
                
                
                  Title Property
                
                
                  TitleBar Property
                
                
                  Toolbar Property
                
                
                  Top Property
                
                
                  Top2 Property
                
                
                  TopLeft Property
                
                
                  TopOffset Property
                
                
                  Total Property
                
                
                  TotalAllMembers Property
                
                
                  TotalBackColor Property
                
                
                  TotalColumnMember Property
                
                
                  TotalFont Property
                
                
                  TotalForeColor Property
                
                
                  TotalMember Property
                
                
                  TotalOrientation Property
                
                
                  TotalPageMember Property
                
                
                  TotalRowHeight Property
                
                
                  TotalRowMember Property
                
                
                  Totals Property
                
                
                  TotalType Property
                
                
                  Type Property
                
              
            
            
              U
              
                
                  Underline Property
                
                
                  UniqueName Property
                
                
                  UniqueTable Property
                
                
                  UsableHeight Property
                
                
                  UsableWidth Property
                
                
                  UsedRange Property
                
                
                  UseRemoteProvider Property
                
                
                  UserMode Property
                
                
                  UseStandardHeight Property
                
                
                  UseStandardWidth Property
                
                
                  UseXMLData Property
                
              
            
            
              V
              
                
                  Value Property
                
                
                  Value2 Property
                
                
                  ValueType Property
                
                
                  Version Property
                
                
                  VerticalAlignment Property
                
                
                  VerticalExtent Property
                
                
                  VerticalExtentMax Property
                
                
                  VerticalPosition Property
                
                
                  View Property
                
                
                  ViewableRange Property
                
                
                  ViewOnlyMode Property
                
                
                  ViewportLeft Property
                
                
                  ViewportTop Property
                
                
                  Visible Property
                
                
                  VisibleRange Property
                
              
            
            
              W
              
                
                  WatermarkBorder Property
                
                
                  WatermarkFont Property
                
                
                  WatermarkInterior Property
                
                
                  Weight Property
                
                
                  Width Property
                
                
                  WidthRatio Property
                
                
                  WindowNumber Property
                
                
                  Windows Property
                
                
                  Workbooks Property
                
                
                  Worksheet Property
                
                
                  Worksheets Property
                
              
            
            
              X
              
                
                  x Property
                
                
                  XMLData Property
                
                
                  XmlDataBindings Property
                
                
                  XMLDataTarget Property
                
                
                  XMLLocation Property
                
                
                  XmlMap Property
                
                
                  XmlMaps Property
                
                
                  XMLURL Property
                
              
            
            
              Y
              
                
                  y Property
                
              
            
            
              Z
              
                
                  ZOrder Property
                
              
            
          
        
        
          Events
          
            
              A
              
                
                  AfterDelete Event
                
                
                  AfterFinalRender Event
                
                
                  AfterInsert Event
                
                
                  AfterLayout Event
                
                
                  AfterRender Event
                
                
                  AfterUpdate Event
                
              
            
            
              B
              
                
                  BeforeCollapse Event
                
                
                  BeforeContextMenu Event
                
                
                  BeforeDelete Event
                
                
                  BeforeExpand Event
                
                
                  BeforeFirstPage Event
                
                
                  BeforeInitialBind Event
                
                
                  BeforeInsert Event
                
                
                  BeforeKeyDown Event
                
                
                  BeforeKeyPress Event
                
                
                  BeforeKeyUp Event
                
                
                  BeforeLastPage Event
                
                
                  BeforeNextPage Event
                
                
                  BeforeOverwrite Event
                
                
                  BeforePreviousPage Event
                
                
                  BeforeRender Event
                
                
                  BeforeScreenTip Event
                
                
                  BeforeUpdate Event
                
                
                  BindingAdded Event
                
                
                  BindingCompleted Event
                
                
                  BindingDeleted Event
                
                
                  BindingError Event
                
                
                  BindingUpdated Event
                
                
                  ButtonClick Event
                
              
            
            
              C
              
                
                  Change Event
                
                
                  Click Event
                
                
                  CommandBeforeExecute Event
                
                
                  CommandChecked Event
                
                
                  CommandEnabled Event
                
                
                  CommandExecute Event
                
                
                  CommandTipText Event
                
                
                  Current Event
                
              
            
            
              D
              
                
                  DataChange Event
                
                
                  DataError Event
                
                
                  DataPageComplete Event
                
                
                  DataSetChange Event
                
                
                  DblClick Event
                
                
                  Dirty Event
                
              
            
            
              E
              
                
                  EndEdit Event
                
              
            
            
              F
              
                
                  Focus Event
                
              
            
            
              I
              
                
                  Initialize Event
                
              
            
            
              K
              
                
                  KeyDown Event
                
                
                  KeyPress Event
                
                
                  KeyUp Event
                
              
            
            
              L
              
                
                  LoadCompleted Event
                
              
            
            
              M
              
                
                  MouseDown Event
                
                
                  MouseMove Event
                
                
                  MouseOut Event
                
                
                  MouseOver Event
                
                
                  MouseUp Event
                
                
                  MouseWheel Event
                
              
            
            
              P
              
                
                  ParametersOutReady Event
                
                
                  PivotTableChange Event
                
              
            
            
              Q
              
                
                  Query Event
                
              
            
            
              R
              
                
                  RecordExit Event
                
                
                  RecordsetSaveProgress Event
                
                
                  RowReady Event
                
              
            
            
              S
              
                
                  SelectionChange Event
                
                
                  SelectionChanging Event
                
                
                  SheetActivate Event
                
                
                  SheetCalculate Event
                
                
                  SheetChange Event
                
                
                  SheetDeactivate Event
                
                
                  SheetFollowHyperlink Event
                
                
                  StartEdit Event
                
              
            
            
              U
              
                
                  Undo Event
                
              
            
            
              V
              
                
                  ViewChange Event
                
              
            
          
        
        
          Enumerations
          
            
              Microsoft Office Web Components Constants
            
          
        
      
    
  


      
    

  

                                                                  

                                                        
                                                        
                                                                
                                                                        
                                                                                Get in touch
                                                                        
                                                                        Submit feedback about this site to:
                                                                        
                                                                                [email protected]
                                                                        
                                                                

                                                        
                                                                
                                                                        © documentation.help. Design: rehmann.co.