DBTable.FilterCases

Filter cases.

Syntax Parameters Return Value
Sub DBTable.FilterCases( _
    UseCaseName As Boolean, _
    Optional Variables As Variant = "*", _
    Optional OutputVariables As Variant = "*", _
    Optional UseSpreadsheetSelCond As Boolean = True, _
    Optional selectionIncludeExpression As String, _
    Optional selectionIncludeList As String, _
    Optional selectionExcludeExpression As String, _
    Optional selectionExcludeList As String, _
    Optional Sorted As Boolean = True, _
    Optional PreserveOrder As Boolean = False, _
    Optional CopyFormatting As Boolean = False, _
    Optional CreateFilteredSpreadsheet As Boolean = True, _
    Optional ByRef FilteredSpreadsheet As Spreadsheet, _
    Optional CreateDuplicatesSpreadsheet As Boolean, _
    Optional ByRef DuplicatesSpreadsheet As Spreadsheet)
  • UseCaseName [in]

    Type: Boolean

  • Variables [in, optional]

    Type: Variant

    Default value: "*"

  • OutputVariables [in, optional]

    Type: Variant

    Default value: "*"

  • UseSpreadsheetSelCond [in, optional]

    Type: Boolean

    Default value: True

  • selectionIncludeExpression [in, optional]

    Type: String

  • selectionIncludeList [in, optional]

    Type: String

  • selectionExcludeExpression [in, optional]

    Type: String

  • selectionExcludeList [in, optional]

    Type: String

  • Sorted [in, optional]

    Type: Boolean

    Default value: True

  • PreserveOrder [in, optional]

    Type: Boolean

    Default value: False

  • CopyFormatting [in, optional]

    Type: Boolean

    Default value: False

  • CreateFilteredSpreadsheet [in, optional]

    Type: Boolean

    Default value: True

  • FilteredSpreadsheet [out, optional]

    Type: Spreadsheet

  • CreateDuplicatesSpreadsheet [in, optional]

    Type: Boolean

  • DuplicatesSpreadsheet [out, optional]

    Type: Spreadsheet

This function does not return a value.