Add Method

Microsoft Office Web Components Object Model

Show All

Add Method

       

Add method as it applies to the ChAxes object.

Adds an axis to a chart. Creates a new ChAxis object.

expression.Add(Scaling)

expression   Required. An expression that returns a ChAxes object.

Scaling  Required ChScaling object. A scaling object from another axis or series.

 

Add method as it applies to the ChCharts object.

Creates a new, empty chart. Returns a ChChart object.

expression.Add(Index)

expression   Required. An expression that returns a ChCharts object.

Index  Optional Long. Specifies the position of the new chart. Specifying zero (0) inserts the chart at the beginning of the collection. The default value is -1, which means that if you do not specify this argument, the new chart is inserted at the end of the collection.

 

Add method as it applies to the ChDataLabelsCollection object.

Adds data labels to the specified series. Creates a new, uninitialized ChDataLabels object and adds it to the specified ChDataLabelsCollection collection. A series can have only one set of data labels; this method fails if the ChDataLabelsCollection collection already contains a ChDataLabels object. 

expression.Add

expression   Required. An expression that returns a ChDataLabelsCollection object.

 

Add method as it applies to the ChErrorBarsCollection object.

Adds error bars to a series. Creates a new, uninitialized ChErrorBars object and adds it to the specified ChErrorBarsCollection collection. A chart can contain only one set of error bars; this means that an XY (Scatter) chart can contain either x or y error bars, but not both. 

expression.Add

expression   Required. An expression that returns a ChErrorBarsCollection object.

 

Add method as it applies to the ChSegments object.

Adds a segment to a format map. Returns a ChSegment object.

expression.Add

expression   Required. An expression that returns a ChSegments object.

 

Add method as it applies to the ChSeriesCollection object.

Adds a series to a chart. Creates a new, empty ChSeries object at the specified position in the ChSeriesCollection collection. 

expression.Add(Index)

expression   Required. An expression that returns a ChSeriesCollection object.

Index  Optional Long. Specifies the position of the new series in the collection. Specifying zero (0) places the new series at the beginning of the collection. The default value is -1, which means if you do not specify this argument, the new series is placed at the end of the collection.

 

Add method as it applies to the ChTrendlines object.

Adds a trendline to a series. Creates a new, uninitialized ChTrendline object and adds it to the end of the specified ChTrendlines collection. Each series can contain only one trendline. 

expression.Add

expression   Required. An expression that returns a ChTrendlines object.

 

Add method as it applies to the ElementExtensions object.

Creates a new ElementExtension object.

expression.Add(ElementID, FailIfThere)

expression   Required. An expression that returns an ElementExtensions object.

ElementID  Required String. Specifies the ID tag of an HTML element that will be extended by the new ElementExtension object.

FailIfThere  Optional Boolean. If this argument is set to True and the object specified by ElementID already has an element extension, the Add method fails. If this argument is set to False (or not specified), the existing element extension is replaced.

 

Add method as it applies to the GroupingDefs object.

Creates a new grouping definition. Returns a GroupingDef object.

expression.Add(GroupingDefName, GroupingFieldName, PageFieldName, Index)

expression   Required. An expression that returns a GroupingDefs object.

GroupingDefName  Required String. Specifies the name of the new grouping definition.

GroupingFieldName  Required String. Specifies the name of the grouping field used to create the new definition.

PageFieldName  Required String. Specifies the name of the page field used to create the new definition.

Index  Optional Variant. Specifies the ordinal position, the name, or the actual object reference for the grouping definition before which the new grouping definition will be added. If you do not specify this argument, the new grouping definition is added at the end of the collection.

Remarks

A recordset definition that represents a grouping level has an object type of GroupingDef, which is derived from the RecordsetDef object representing the recordset definition. As far as control binding is concerned, a recordset defined by a GroupingDef object behaves just like a recordset defined by a RecordsetDef object.

 

Add method as it applies to the GroupLevels object.

Creates a new group level. Returns a GroupLevel object.

expression.Add(RecordSource, FailIfThere)

expression   Required. An expression that returns a GroupLevels object.

RecordSource  Required String. Specifies the name of the record source for the new group level.

FailIfThere  Optional Boolean. If this argument is set to True and the new group level already exists, the Add method fails. The default value is False.

 

Add method as it applies to the Sheets and Worksheets objects.

Creates a new worksheet. The new worksheet becomes the active sheet.

expression.Add(Before, After, Count, Type)

expression   Required. An expression that returns one of the above objects.

Before  Optional Variant. An object that specifies the sheet before which the new sheet is added.

After  Optional Variant. Optional Variant. An object that specifies the sheet after which the new sheet is added.

Count  Optional Variant. The number of sheets to be added. The default value is one.

Type  Optional Variant. Specifies the sheet type. Can be one of the following XlSheetType constants: xlWorksheet.

Remarks

If Before and After are both omitted, the new sheet is inserted before the active sheet.

 

Add method as it applies to the PageFields object.

Creates a new page field. Returns a PageField object.

expression.Add(Source, FieldType, Name, TotalType, Index)

expression   Required. An expression that returns one a PageFields object.

Source  Required Variant. Specifies the source for the new page field. For new fields of type dscOutput, this argument specifies a SchemaField object or the name of a schema field. For fields of type dscCalculated, this argument specifies the expression for the calculated field. For new fields of type dscGrouping, this argument specifies a PageField object or the name of a page field on which this grouping is based

FieldType  Optional Variant. Specifies the new field type. The default value and allowed values depend on the parent object used with this method. For more information, see the “Remarks” section in this topic.

Name  Optional Variant. Specifies the name of the new page field. If you do not specify this argument, the name of an output field is the same as the schema field it is based on, the name of a grouping field is "By<pagefieldname>" or "<agg function>of<pagefieldname>", and the name of a calculated field is "Expr". In all cases, numerals are automatically appended to the new name to make it unique, if necessary.

TotalType  Optional DscTotalTypeEnum. The type of total.

DscTotalTypeEnum can be one of these DscTotalTypeEnum constants.
dscAny
dscAvg
dscCount
dscMax
dscMin
dscNone default
dscStdev
dscSum

Index  Optional Variant. Specifies the ordinal position, the name, or the actual object reference for the page field before which the new page field is added. If you do not specify this argument, the new page field is added at the end of the collection. Use this argument only with a GroupingDef object's PageFields collection. For more information, see the “Remarks” section following this paragraph.

Remarks

The PageFields collection has three different parent objects: RecordsetDef, PageRowsource, and GroupingDef. You use the same Add method for all of these parent objects. There are, however, some differences in defaults and allowed values depending on which parent object you use.

  • For RecordsetDef.PageFields.Add, the default value for FieldType is dscOutput. Other allowed FieldType values are dscCalculated and dscGrouping. When FieldType is dscOutput, the specified source field will be added to the primary page row source in the recordset definition; thus, the source field must exist in the corresponding schema row source. When FieldType is dscGrouping, the TotalType value must be something other than dscNone (a nonaggregate grouping field can exist only in a grouping definition, not in a recordset definition). You cannot use the Index argument in this scenario.
  • For PageRowsource.PageFields.Add, the default and only allowed value for FieldType is dscOutput. The only allowed value for TotalType is dscNone. You cannot use the Index argument in this scenario. Using the Add method, you can add output fields to look up row sources.
  • For GroupingDef.PageFields.Add, the default value for FieldType is dscGrouping. The other allowed FieldType value is dscCalculated. You can use the Index argument in this scenario (sequence is important in groupings of definitions).

 

Add method as it applies to the LookupRelationships and SublistRelationships objects.

Creates a new lookup join relationship or a new sublist relationship. Returns a PageRelationship object.

expression.Add(PageRowsource, SchemaRelationship)

expression   Required. An expression that returns one of the above objects.

PageRowsource  Required PageRowsource object. Specifies the page row source on the “one” side of the one-to-many page relationship.

SchemaRelationship  Required SchemaRelationship object. Describes the connecting fields between the parent page row source on the “many” side of the one-to-many relationship and the page row source specified in this method.

Remarks

The SublistRelationships collection contains PageRelationship objects of type dscSublist for which a RecordsetDef object is the “one” side (the parent) of a one-to-many relationship.

 

Add method as it applies to the ParameterValues object.

Creates a new parameter value. Returns a ParameterValue object.

expression.Add(ParameterName, Value)

expression   Required. An expression that returns a ParameterValues object.

ParameterName  Required String. Specifies the parameter name.

Value  Optional Variant. Specifies the value of the parameter.

 

Add method as it applies to the RecordsetDefs object.

Creates a new recordset definition. Returns a RecordsetDef object.

expression.Add(SchemaRowsource, Name)

expression   Required. An expression that returns a RecordsetDefs object.

SchemaRowsource  Required Variant. Specifies the schema row source that will be used to create the new recordset definition. This argument can be a SchemaRowsource object or the name of an existing schema row source.

Name  Optional Variant. Specifies the name of the new recordset definition. If you do not specify this argument, the new recordset definition has the same name as the schema row source specified by the SchemaRowsource argument; if necessary, numerals are automatically appended to the new name to make it unique.

Remarks

Using a single AddNew method call, you can create a recordset definition, page row source, and schema row source.

 

Add method as it applies to the SchemaFields object.

Creates a new schema field. Returns a SchemaField object.

expression.Add(Name, DataType, Length)

expression   Required. An expression that returns a SchemaFields object.

Name  Required String. Specifies the name of the new schema field.

DataType  Required ADO DataTypeEnum. Specifies the data type of the new schema field.

Length  Optional Variant. Specifies the length of the new schema field.

Remarks

In design mode in Microsoft Access, the SchemaFields collection is automatically filled with the available schema fields.

 

Add method as it applies to the SchemaParameters object.

Creates a new schema parameter. Returns a SchemaParameter object.

expression.Add(Name, DataType, Size, Scale, Precision, Direction)

expression   Required. An expression that returns a SchemaParameters object.

Name  Required String. Specifies the name of the new schema parameter.

DataType  Optional Variant. Specifies the data type of the new schema parameter. Can be one of the ADO DataTypeEnum constants.

Size  Optional Variant. Specifies the maximum length of the new schema parameter.

Scale  Optional Variant. Specifies the maximum number of digits to the right of the decimal point.

Precision  Optional Variant. Specifies the maximum number of digits used for the parameter.

Direction  Optional Variant. Specifies whether the parameter is an input parameter, an output parameter, both an input and output parameter, or a procedure return value. As only input parameters are supported, you should not specify this argument.

Remarks

In design mode in Microsoft Access, the SchemaParameters collection is automatically filled with the available schema parameters.

 

Add method as it applies to the SchemaRelatedFields object.

Creates a new related field. Returns a SchemaRelatedField object.

expression.Add(ManySchemaField, OneSchemaField)

expression   Required. An expression that returns a SchemaRelatedFields object.

ManySchemaField   Required String. Specifies the name of the schema field on the “one” side of the one-to-many relationship.

OneSchemaField   Required String. Specifies the name of the schema field on the “many” side of the one-to-many relationship.

Remarks

A SchemaRelatedField object describes the column pairings that make up a SchemaRelationship object. The names of these fields are used in generating join clauses in SQL and parent-child relationships in a hierarchy.

In design mode in Microsoft Access, the SchemaFields collection is automatically filled with the available schema fields.

 

Add method as it applies to the SchemaRelationships object.

Creates a new schema relationship. Returns a SchemaRelationship object.

expression.Add(Name, ManySchemaRowsource, OneSchemaRowsource, ManySchemaField, OneSchemaField)

expression   Required. An expression that returns a SchemaRelationships object.

Name   Required String. Specifies the name of the new schema relationship.

ManySchemaRowsource   Required String. Specifies the name of the row source on the “many” side of this one-to-many relationship.

OneSchemaRowsource   Required String. Specifies the name of the row source on the “one” side of this one-to-many relationship.

ManySchemaField   Required String. Specifies the name of the schema field on the “many” side of this one-to-many relationship.

OneSchemaField   Required String. Specifies the name of the schema field on the “one” side of this one-to-many relationship.

Remarks

In design mode in Microsoft Access, the SchemaRelationships collection is automatically filled with the available schema relationships.

 

Add method as it applies to the SchemaRowsources object.

Creates a new schema row source. Returns a SchemaRowSource object.

expression.Add(Name, RowsourceType, CommandText)

expression   Required. An expression that returns a SchemaRowsources object.

Name  Required String. Specifies the name of the new row source.

RowsourceType  Required DscRowsourceTypeEnum. Specifies the type of the new row source.

DscRowsourceTypeEnum can be one of these DscRowsourceTypeEnum constants.
dscCommandFile
dscCommandText
dscFunction
dscInlineFunction
dscProcedure
dscTable
dscTableFunction
dscView

CommandText  Optional Variant. The schema row source command text. For more information, see the Help topic for the CommandText property.

Remarks

In design mode in Microsoft Access, the SchemaRowsources collection is automatically filled with the available schema row sources.

 

Add method as it applies to the Criteria object.

Adds an AutoFilter criterion.

expression.Add(Criterion)

expression   Required. An expression that returns a Criteria object.

Criterion  Required String. Specifies the new criterion.

 

Add method as it applies to the Names object.

Defines a new name. Returns a Name object.

expression.Add(Name, RefersTo, Visible, MacroType, ShortcutKey, Category, NameLocal, RefersToLocal, CategoryLocal, RefersToR1C1, RefersToR1C1Local)

expression   Required. An expression that returns a Names object.

Name  Optional Variant. Required if NameLocal isn’t specified. The text to use as the name (in the language of the macro). Names cannot include spaces and cannot look like cell references.

RefersTo  Optional Variant. Required unless one of the other RefersTo arguments is specified. Describes what the name refers to (in the language of the macro, using A1-style notation).

Visible  Optional Variant. This argument is not supported.

MacroType  Optional Variant. This argument is not supported.

ShortcutKey  Optional Variant. This argument is not supported.

Category  Optional Variant. This argument is not supported.

NameLocal  Optional Variant. Required if Name isn’t specified. The text to use as the name (in the language of the user). Names cannot include spaces and cannot look like cell references.

RefersToLocal  Optional Variant. Required unless one of the other RefersTo arguments is specified. Describes what the name refers to (in the language of the user, using A1-style notation).

CategoryLocal  Optional Variant. Required if Category isn’t specified. Text identifying the category of a custom function in the language of the user.

RefersToR1C1  Optional Variant. Required unless one of the other RefersTo arguments is specified. Describes what the name refers to (in the language of the macro, using R1C1-style notation).

RefersToR1C1Local  Optional Variant. Required unless one of the other RefersTo arguments is specified. Describes what the name refers to (in the language of the user, using R1C1-style notation).

 

Example

As it applies to the ChCharts object.

This example adds a chart to the chart workspace.

Set cht = ChartSpace1.Charts.Add

As it applies to the ChDataLabelsCollection object.

This example adds data labels to the specified series in the chart workspace.

Set ch = ChartSpace1.Charts(0)
ch.SeriesCollection(0).DataLabelsCollection.Add

As it applies to the ChErrorBarsCollection object.

This example adds error bars to the specified series in the chart workspace.

Set eb = ChartSpace1.Charts(0).SeriesCollection(0).ErrorBarsCollection.Add

As it applies to the ChSeriesCollection object.

This example adds a new series to the specified chart in the chart workspace and then sets the values for the new series.

Dim values(7)

values(0) = 0
values(1) = 1
values(2) = 10
values(3) = 25
values(4) = 30
values(5) = 40
values(6) = 60

Set s2 = ChartSpace1.Charts(0).SeriesCollection.Add
Set c = ChartSpace1.Constants
s2.SetData c.chDimValues, c.chDataLiteral, values

As it applies to the ChTrendlines object.

This example adds a trendline to the specified series in the chart workspace.

Set trndline = ChartSpace1.Charts(0).SeriesCollection(0).Trendlines.Add

As it applies to the Criteria object.

This example turns on the AutoFilter for the range A1:J22, and then it sets filters for columns 1 and 3 and applies the filters.

Spreadsheet1.Range("a1:j22").AutoFilter
Set af = Spreadsheet1.ActiveSheet.AutoFilter
Set filterColumnOne = af.Filters(1)
Set filterColumnThree = af.Filters(3)
filterColumnOne.Criteria.Add "blue" ' Don't show blue in column 1.
filterColumnOne.Criteria.Add "green" ' Don't show green in column 1.
filterColumnThree.Criteria.Add "yellow" ' Don't show yellow in column 3.
af.Apply