Spreadsheet.MergeVariablesPO
This function merges the spreadsheet variables with the variables of the specified file.
| Syntax | Parameters | Return Value |
|---|---|---|
Function Spreadsheet.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
|
Type: Variant Type: SpreadsheetType1 Type: Variant Type: Variant Type: String Default value: "" Type: Boolean Default value: False Type: Variant Type: Variant Type: SpreadsheetType2 Default value: scMergeFillWithMD Type: SpreadsheetType2 Default value: scMergeFillWithMD Type: Boolean Default value: False Type: Boolean Default value: False Type: Boolean Default value: False Type: Boolean Default value: False 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: Variant Type: Variant Type: Boolean Default value: False Type: Boolean Default value: False Type: Boolean Default value: False Type: Boolean Default value: False |
Spreadsheet |