DBTable.SubsetEx2

Creates a new spreadsheet containing the specified subset of the current spreadsheet using Selection Conditions.

This property is read only.

Syntax Parameters Return Value 
ReadOnly Property DBTable.SubsetEx2( _
    Variables As Variant, _
    Optional UseSpreadsheetSelCond As Boolean = True, _
    Optional CopyFormatting As Boolean = False, _
    Optional selectionIncludeExpression As String = "", _
    Optional selectionIncludeList As String = "", _
    Optional selectionExcludeExpression As String = "", _
    Optional selectionExcludeList As String = "", _
    Optional CreateSpreadsheet As Boolean = True) As Spreadsheet
  • Variables [in]

    Type: Variant

  • UseSpreadsheetSelCond [in, optional]

    Type: Boolean

    Default value: True

  • CopyFormatting [in, optional]

    Type: Boolean

    Default value: False

  • selectionIncludeExpression [in, optional]

    Type: String

    Default value: " "

  • selectionIncludeList [in, optional]

    Type: String

    Default value: " "

  • selectionExcludeExpression [in, optional]

    Type: String

    Default value: " "

  • selectionExcludeList [in, optional]

    Type: String

    Default value: " "

  • CreateSpreadsheet [in, optional]

    Type: Boolean

    Default value: True

Spreadsheet