Identical to Compare, but with additional parameters to control the colors that are used in reports.
•all the worksheets in one workbook all of the worksheets in another
•a subset of the worksheets in one workbook with the equivalently named worksheets in another
•one worksheet with another worksheet
Applies to
SYNTAX
Set result = expression.CompareWIthColors(bookOrSheets1, bookOrSheets2, testFormulas, ignoreCase, styleA1, alignRows, alignColumns, highlightDifferences, writeReport, groupEquivalentChanges, rowAlignmentColumns, columnAlignmentRows, win32ModifiedCellColor, win32DeletedCellColor, win32AddedCellColor, win32BlankAlignmentRowColor, win32BlankAlignmentColumnColor, win32ArrayMembershipColor)
expression Required. An expression that returns an IOAKAPI object.
result An ICompareResult object that gives access to the results of the comparison.
bookOrSheets1, bookOrSheets2, testFormulas, ignoreCase, styleA1, alignRows, alignColumns, highlightDifferences, writeReport, groupEquivalentChanges, rowAlignmentColumns, columnAlignmentRows: These parameters are identical to those of the Compare method.
win32ModifiedCellColor, win32DeletedCellColor, win32AddedCellColor, win32BlankAlignmentRowColor, win32BlankAlignmentColumnColor, win32ArrayMembershipColor: Required Longs which specify the colors to be used for when marking comparison results on a worksheet.
These colors are equivalent to the ones which may be specified through the user interface by pressing the Set Colors button in the dialog presented when the OAK Review | Compare | Workbooks/Worksheets command is invoked.
