Microsoft Office Web Components Visual Basic Reference
Unknown
Table of contents
Microsoft Office Web Components Object Models
What's New for Microsoft Office Web Components Developers
Programming Concepts
Microsoft Office Chart Workspace Examples
Declaring and Using Event Procedures in VBScript
Using Named Constants in VBScript
Objects
A-B
AllGroupingDefs Collection Object
AllPageFields Collection Object
AutoFilter Object
Border Object
Borders Collection Object
ByRef Object
C
ChartSpace Object
ChAxes Collection
ChAxis Object
ChBorder Object
ChCategoryLabel Object
ChCategoryLabels Collection
ChChart Object
ChChartDraw Object
ChChartField Object
ChChartFields Object
ChCharts Collection
ChDataLabel Object
ChDataLabels Object
ChDataLabelsCollection Collection
ChDropZone Object
ChErrorBars Object
ChErrorBarsCollection Object
ChFont Object
ChFormatMap Object
ChGridlines Object
ChInterior Object
ChLegend Object
ChLegendEntries Collection
ChLegendEntry Object
ChLine Object
ChMarker Object
ChPlotArea Object
ChPoint Object
ChPoints Collection
ChScaling Object
ChSegment Object
ChSegmentBoundary Object
ChSegments Object
ChSeries Object
ChSeriesCollection Collection
ChSurface Object
ChTitle Object
ChTrendline Object
ChTrendlines Collection
ChUserDefinedSelection Object
Coordinate Object
Criteria Object
D-E
DataPage Object
DataPages Collection Object
DataSourceControl Object
DSCEventInfo Object
ElementExtension Object
ElementExtensions Collection Object
F-G
Filter Object
Filters Collection Object
Font Object
GroupingDef Object
GroupingDefs Collection Object
GroupLevel Object
GroupLevels Collection Object
H-L
Heading Object
Headings Object
Hyperlink Object
Interior Object
LookupRelationships Collection Object
LookupSchemaRelationships Collection Object
N-O
Name Object
Names Collection
OCCommand Object
OCCommands Object
OWCLanguageSettings Object
P
PageField Object
PageFields Collection Object
PageRelatedField Object
PageRelatedFields Collection Object
PageRelationship Object
PageRowsource Object
PageRowsources Collection Object
Pane Object
Panes Collection Object
ParameterValue Object
ParameterValues Collection Object
PivotAggregate Object
PivotAggregates Collection Object
PivotAxis Object
PivotAxisMember Object
PivotAxisMembers Collection
PivotCell Object
PivotColumnMember Object
PivotColumnMembers Collection
PivotData Object
PivotDataAxis Object
PivotDetailCell Object
PivotDetailRange Object
PivotField Object
PivotFields Collection Object
PivotFieldSet Object
PivotFieldSets Collection Object
PivotFilterAxis Object
PivotFont Object
PivotGroupAxis Object
PivotHyperlink Object
PivotLabel Object
PivotMember Object
PivotMemberProperties Collection
PivotMemberProperty Object
PivotMembers Collection Object
PivotPageMember Object
PivotPageMembers Collection
PivotRange Object
PivotResultAxis Object
PivotResultColumnAxis Object
PivotResultDataAxis Object
PivotResultField Object
PivotResultFilterAxis Object
PivotResultGroupAxis Object
PivotResultGroupField Object
PivotResultGroupFields Collection
PivotResultLabel Object
PivotResultMemberProperties Collection
PivotResultMemberProperty Object
PivotResultPageAxis Object
PivotResultRowAxis Object
PivotRowMember Object
PivotRowMembers Collection
PivotTable Object
PivotTotal Object
PivotTotals Collection Object
PivotView Object
Protection Object
R-S
Range Object
RecordNavigationControl Object
RecordsetDef Object
RecordsetDefs Collection Object
SchemaField Object
SchemaFields Collection Object
SchemaParameter Object
SchemaParameters Collection Object
SchemaRelatedField Object
SchemaRelatedFields Collection Object
SchemaRelationship Object
SchemaRelationships Collection Object
SchemaRowsource Object
SchemaRowsources Collection Object
Section Object
Sheets Collection
Spreadsheet Object
SublistRelationships Collection Object
SublistSchemaRelationships Collection Object
T-W
TitleBar Object
Window Object
Windows Collection Object
Workbook Object
Workbooks Collection
Worksheet Object
Worksheets Collection
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-C
BeginObject Method
BeginUndo Method
BorderAround Method
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
ExportPicture Method
ExportXML Method
F
FillDown Method
FillRight Method
Find Method
FindNext Method
FindPrevious Method
FlipHorizontal Method
FlipVertical Method
Follow Method
G-H
GetContainingSection Method
GetPicture Method
GetValue Method
Group Method
HideDetails Method
I
Insert Method
InsertFieldSet Method
InsertTotal Method
IsButtonEnabled Method
Item Method
L-M
LargeScroll Method
Load Method
LoadText Method
MakeCurrent Method
Merge Method
Move Method
MoveDetailLeft Method
MoveDetailTop Method
MoveFirst Method
MoveLast Method
MoveLeft Method
MoveNext Method
MovePrevious Method
MoveTop Method
N-P
NewRecord Method
Nz Method
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
SetData Method
SetOneColorGradient Method
SetPatterned 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-V
TextHeight Method
TextWidth Method
ToggleFilter Method
Undo Method
Ungroup Method
UnMerge Method
Unprotect Method
UpdatePropertyToolbox Method
ValueToPoint Method
Properties
A
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
AllPageFields Property
AlternateDataSource Property
AlternateRowColor Property
AlwaysIncludeInCube Property
AmbientLightIntensity Property
Amount Property
Application Property
AspectRatio Property
AutoFilter Property
AutoFilterMode Property
AutoFit Property
Axes Property
Axis Property
B
BackColor Property
BackWall Property
BaseName Property
Begin 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
CanUndo 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
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
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
Height Property
HeightRatio Property
Hidden Property
HoleSize Property
HorizontalAlignment Property
HTMLContainer Property
HTMLData Property
HTMLURL Property
Hwnd Property
Hyperlink Property
I
id Property
Inclination Property
Include Property
IncludedMembers Property
Index 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-L
JoinType Property
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
ListRowSource Property
Location Property
Locked Property
LogBase Property
LookupRelationships Property
LookupSchemaRelationships Property
M
MajorGridlines Property
MajorTickMarks Property
MajorUnit Property
MajorVersion Property
ManySide 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
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
Section Property
Segments Property
SelectedSheets Property
Selection 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
Trendlines 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
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-Z
X Property
XMLData Property
XMLDataTarget Property
XMLLocation Property
XMLURL Property
Y Property
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
BeforeQuery Event
BeforeRender Event
BeforeScreenTip Event
BeforeUpdate 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-K
EndEdit Event
Focus Event
Initialize Event
KeyDown Event
KeyPress Event
KeyUp Event
L-M
LoadCompleted Event
MouseDown Event
MouseMove Event
MouseOut Event
MouseOver Event
MouseUp Event
MouseWheel Event
O-R
OnConnect Event
OnDisconnect Event
PivotTableChange Event
Query Event
RecordExit Event
RecordsetSaveProgress Event
S-V
SelectionChange Event
SelectionChanging Event
SheetActivate Event
SheetCalculate Event
SheetChange Event
SheetDeactivate Event
SheetFollowHyperlink Event
StartEdit Event
Undo Event
ViewChange Event
next page