DBTable.SubsetSplitSpreadsheetEx

Creates two new spreadsheets by splitting the current spreadsheet using a probability value.

Syntax Parameters Return Value 
Sub DBTable.SubsetSplitSpreadsheetEx( _
    Variables As Variant, _
    selectionIncludeExpression As String, _
    selectionIncludeList As String, _
    selectionExcludeExpression As String, _
    selectionExcludeList As String, _
    dProb As Double, _
    bQuickRand As Boolean, _
    bUseSpreadsheetSelCond As Boolean, _
    bUseCaseWiseMDDeletion As Boolean, _
    CopyFormatting As Boolean, _
    ByRef LeftSpreadsheet As Spreadsheet, _
    ByRef RightSpreadsheet As Spreadsheet)
  • Variables [in]

    Type: Variant

  • selectionIncludeExpression [in]

    Type: String

  • selectionIncludeList [in]

    Type: String

  • selectionExcludeExpression [in]

    Type: String

  • selectionExcludeList [in]

    Type: String

  • dProb [in]

    Type: Double

  • bQuickRand [in]

    Type: Boolean

  • bUseSpreadsheetSelCond [in]

    Type: Boolean

  • bUseCaseWiseMDDeletion [in]

    Type: Boolean

  • CopyFormatting [in]

    Type: Boolean

  • LeftSpreadsheet [out]

    Type: Spreadsheet

  • RightSpreadsheet [out]

    Type: Spreadsheet

This function does not return a value.