Section (Object)

Member of:

Section collection

Description:

Represents the base object from which all section objects are derived. It is used to access object in a section other than the one containing the script.

Example:

This example shows how to activate the Sales Chart section, activate the legend, use International Sales Report as title, make the chart type horizontal bar chart, and export the chart to intlchrt.htm.

myChart = ActiveDocument.Sections["Sales Chart"]
myChart.Activate()
myChart.ShowLegend = true
myChart.Title  = "International Sales Report"
myChart.ChartType = bqChartTypeHorizontalBar

Methods:

Activate(), Copy(), CustomSQLFrom(String CustomSQLStr), CustomSQLWhere(String CustomSQLStr), Duplicate(), Export(Filename As String, FileFormat As BqExportFileFormat, [optional] IncludeHeaders as Boolean, [optional] Prompt as Boolean), ExportToStream([optional] Filename as String, [optional] FileFormat as BqExportFileFormat, [optional] IncludeHeaders as Boolean, [optional] DataStreaming as Boolean, [optional] Prompt as Boolean), ImportSQLFile(Filename as String, numColumns as Number), PrintOut([optional] FromPage as Number, [optional] ToPage as Number, [optional] Copies as Number, [optional] Filename as String, [optional Prompt as Boolean), Process(), ProcessStoredProc(), ProcessToTable[Tablename as String, ProcessType as BqProcessType, [optional] Grantee as string, Recalculate(), Remove(), ResetCustomSQL{}, SetStoredProcParam(Value parameter, [optional] ParamIndex as Number)

Properties:

Read-only: Property Active As Boolean, Property LastSQLStatement as String, Process QuerySize as Number, Property Type As BqSectionType

Read-write: Property AutoProcess as Boolean, Property IncludeInProcessAll, Property Index As Number, Property Name As String, Property ProcessSequenceNum as Number, Property RowLimit as Number, Property Property RowLimitAcitve as Boolean, Property SaveResults as Boolean, Property ShowOutliner as Boolean, Property ShowSortLine as Boolean, Property TimeLimit as Number, Property TimeLimitActive as Boolean, Property UniqueRows as Boolean, Property Visible As Boolean

Constants:

The FileFormat method of the Section (Object) uses the BqExportFileFormat constant group. The BqExportFileFormat constant group consists of these values:·