DBTable.MergeVariablesPO

Merges the spreadsheet variables with the variables of the specified file.

Syntax Parameters Return Value
Function DBTable.MergeVariablesPO( _
    Input As Variant, _
    mergeType As SpreadsheetType1, _
    keys1 As Variant, _
    keys2 As Variant, _
    Optional outFile As String = "", _
    Optional bOverwrite As Boolean = False, _
    Optional SortOrders As Variant, _
    Optional SortTypes As Variant, _
    Optional unmatched1 As SpreadsheetType2 = scMergeFillWithMD, _
    Optional unmatched2 As SpreadsheetType2 = scMergeFillWithMD, _
    Optional bDropMultiples1 As Boolean = False, _
    Optional bDropMultiples2 As Boolean = False, _
    Optional applySelCond1 As Boolean = False, _
    Optional applySelCond2 As Boolean = False, _
    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 selectedVars1 As Variant, _
    Optional selectedVars2 As Variant, _
    Optional bCopyFormatting1 As Boolean = False, _
    Optional bCopyFormatting2 As Boolean = False, _
    Optional bVerifySorted As Boolean = False, _
    Optional bPreserveOrder As Boolean = False) As Spreadsheet
  • Input [in]

    Type: Variant

  • mergeType [in]

    Type: SpreadsheetType1

  • keys1 [in]

    Type: Variant

  • keys2 [in]

    Type: Variant

  • outFile [in, optional]

    Type: String

    Default value: " "

  • bOverwrite [in, optional]

    Type: Boolean

    Default value: False

  • SortOrders [in, optional]

    Type: Variant

  • SortTypes [in, optional]

    Type: Variant

  • unmatched1 [in, optional]

    Type: SpreadsheetType2

    Default value: scMergeFillWithMD

  • unmatched2 [in, optional]

    Type: SpreadsheetType2

    Default value: scMergeFillWithMD

  • bDropMultiples1 [in, optional]

    Type: Boolean

    Default value: False

  • bDropMultiples2 [in, optional]

    Type: Boolean

    Default value: False

  • applySelCond1 [in, optional]

    Type: Boolean

    Default value: False

  • applySelCond2 [in, optional]

    Type: Boolean

    Default value: False

  • 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: " "

  • selectedVars1 [in, optional]

    Type: Variant

  • selectedVars2 [in, optional]

    Type: Variant

  • bCopyFormatting1 [in, optional]

    Type: Boolean

    Default value: False

  • bCopyFormatting2 [in, optional]

    Type: Boolean

    Default value: False

  • bVerifySorted [in, optional]

    Type: Boolean

    Default value: False

  • bPreserveOrder [in, optional]

    Type: Boolean

    Default value: False

Spreadsheet