DBTable.MultipleSubsetByGroup

Create multiple subset spreadsheets of this spreadsheet based on unique combinations of the grouping variables.

Syntax Parameters Return Value
Function DBTable.MultipleSubsetByGroup( _
    groupVars As Variant, _
    includeVars As Variant, _
    Optional howToSort As SortOption = scSortOptionUnsorted, _
    Optional useSelectionConditions As Boolean = True, _
    Optional maxNumberOfGroupsToCreate As Long = -1, _
    Optional maxNumberOfGroupsToCount As Long = -1, _
    Optional bAllowFileBased As Boolean = True, _
    Optional ByRef groupCaseNumbers As Variant, _
    Optional ByRef numberOfCasesPerGroup As Variant, _
    Optional ByRef numberOfGroups As Variant, _
    Optional ByRef isFileBased As Variant) As Variant
  • groupVars [in]

    Type: Variant

  • includeVars [in]

    Type: Variant

  • howToSort [in, optional]

    Type: SortOption

    Default value: scSortOptionUnsorted

  • useSelectionConditions [in, optional]

    Type: Boolean

    Default value: True

  • maxNumberOfGroupsToCreate [in, optional]

    Type: Long

    Default value: -1

  • maxNumberOfGroupsToCount [in, optional]

    Type: Long

    Default value: -1

  • bAllowFileBased [in, optional]

    Type: Boolean

    Default value: True

  • groupCaseNumbers [in, out, optional]

    Type: Variant

  • numberOfCasesPerGroup [in, out, optional]

    Type: Variant

  • numberOfGroups [out, optional]

    Type: Variant

  • isFileBased [out, optional]

    Type: Variant

Variant