Spreadsheet.MergeVariablesMatchingEx
Extended matching variables merge. Defaults to relational matching, fill unmatched with MD, auto determine text/numeric comparison, match by casename, all output variables, no selection conditions, keep multiples, no formatting, and spreadsheet creation.
| Syntax | Parameters | Return Value |
|---|---|---|
Function Spreadsheet.MergeVariablesMatchingEx( _
Optional Input As Variant = 0, _
Optional Type As SpreadsheetType1 = scMergeRelational, _
Optional Unmatched1 As SpreadsheetType2 = scMergeFillWithMD, _
Optional Unmatched2 As SpreadsheetType2 = scMergeFillWithMD, _
Optional MatchBy As SpreadsheetType3 = scMergeAuto, _
Optional MatchVariables1 As Variant = 0, _
Optional MatchVariables2 As Variant = 0, _
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 DropMultiples1 As Boolean = False, _
Optional DropMultiples2 As Boolean = False, _
Optional CopyFormatting1 As Boolean = False, _
Optional CopyFormatting2 As Boolean = False, _
Optional VerifySorted As Boolean = False, _
Optional PreserveOrder As Boolean = False, _
Optional CurrentIsSorted As Boolean = False, _
Optional MergeIsSorted As Boolean = False, _
Optional CreateSpreadsheet As Boolean = True) As Spreadsheet
|
Type: Variant Default value: 0 Type: SpreadsheetType1 Default value: scMergeRelational Type: SpreadsheetType2 Default value: scMergeFillWithMD Type: SpreadsheetType2 Default value: scMergeFillWithMD Type: SpreadsheetType3 Default value: scMergeAuto Type: Variant Default value: 0 Type: Variant Default value: 0 Type: Variant Default value: 0 Type: Variant Default value: 0 Type: String Default value: "" Type: String Default value: "" Type: String Default value: "" Type: String Default value: "" Type: String Default value: "" Type: String Default value: "" Type: String Default value: "" Type: String Default value: "" Type: Boolean Default value: False Type: Boolean Default value: False Type: Boolean Default value: False Type: Boolean Default value: False Type: Boolean Default value: False Type: Boolean Default value: False Type: Boolean Default value: False Type: Boolean Default value: False Type: Boolean Default value: True |
Spreadsheet |