Function DBTable.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
|
- Input [in, optional]
Type: Variant
Default value: 0
- Type [in, optional]
Type: SpreadsheetType1
Default value: scMergeRelational
- Unmatched1 [in, optional]
Type: SpreadsheetType2
Default value: scMergeFillWithMD
- Unmatched2 [in, optional]
Type: SpreadsheetType2
Default value: scMergeFillWithMD
- MatchBy [in, optional]
Type: SpreadsheetType3
Default value: scMergeAuto
- MatchVariables1 [in, optional]
Type: Variant
Default value: 0
- MatchVariables2 [in, optional]
Type: Variant
Default value: 0
- 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: " "
- DropMultiples1 [in, optional]
Type: Boolean
Default value: False
- DropMultiples2 [in, optional]
Type: Boolean
Default value: False
- CopyFormatting1 [in, optional]
Type: Boolean
Default value: False
- CopyFormatting2 [in, optional]
Type: Boolean
Default value: False
- VerifySorted [in, optional]
Type: Boolean
Default value: False
- PreserveOrder [in, optional]
Type: Boolean
Default value: False
- CurrentIsSorted [in, optional]
Type: Boolean
Default value: False
- MergeIsSorted [in, optional]
Type: Boolean
Default value: False
- CreateSpreadsheet [in, optional]
Type: Boolean
Default value: True
|
Spreadsheet
|
