DBTable.MergeCasesEx2

Second extended case data merge.

Syntax Parameters Return Value
Function DBTable.MergeCasesEx2( _
    Optional Input As Variant = 0, _
    Optional Recode As SpreadsheetType4 = scMergeAdjustText, _
    Optional OutputVariables1 As Variant = 0, _
    Optional OutputVariables2 As Variant = 0, _
    Optional selectionIncludeExpression1 As String = "", _
    Optional selectionIncludeList1 As String = "", _
    Optional selectionExcludeExpression1 As String = "", _
    Optional selectionExcludeList1 As String = "", _
    Optional selectionIncludeExpression2 As String = "", _
    Optional selectionIncludeList2 As String = "", _
    Optional selectionExcludeExpression2 As String = "", _
    Optional selectionExcludeList2 As String = "", _
    Optional MatchByVarName As Boolean = False, _
    Optional DropUnMatchVar As Boolean = False, _
    Optional CopyFormatting1 As Boolean = False, _
    Optional CopyFormatting2 As Boolean = False, _
    Optional CreateSpreadsheet As Boolean = True) As Spreadsheet
  • Input [in, optional]

    Type: Variant

    Default value: 0

  • Recode [in, optional]

    Type: SpreadsheetType4

    Default value: scMergeAdjustText

  • OutputVariables1 [in, optional]

    Type: Variant

    Default value: 0

  • OutputVariables2 [in, optional]

    Type: Variant

    Default value: 0

  • selectionIncludeExpression1 [in, optional]

    Type: String

    Default value: " "

  • selectionIncludeList1 [in, optional]

    Type: String

    Default value: " "

  • selectionExcludeExpression1 [in, optional]

    Type: String

    Default value: " "

  • selectionExcludeList1 [in, optional]

    Type: String

    Default value: " "

  • selectionIncludeExpression2 [in, optional]

    Type: String

    Default value: " "

  • selectionIncludeList2 [in, optional]

    Type: String

    Default value: " "

  • selectionExcludeExpression2 [in, optional]

    Type: String

    Default value: " "

  • selectionExcludeList2 [in, optional]

    Type: String

    Default value: " "

  • MatchByVarName [in, optional]

    Type: Boolean

    Default value: False

  • DropUnMatchVar [in, optional]

    Type: Boolean

    Default value: False

  • CopyFormatting1 [in, optional]

    Type: Boolean

    Default value: False

  • CopyFormatting2 [in, optional]

    Type: Boolean

    Default value: False

  • CreateSpreadsheet [in, optional]

    Type: Boolean

    Default value: True

Spreadsheet