CompareWorkbooks, CompareWorksheets

Activates the Compare Workbooks or Compare Worksheets user interface, in order to do the following:

•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

IOAKAddIn

SYNTAX

Set result = expression.CompareWorkbooks

Set result = expression.CompareWorksheetds

expression   Required.  An expression that returns an IOAKAddIn object.

result:   An OAKResult enumeration indicating the success or otherwise of the action.

Remarks

When applied to an IOAKAddIn object, the CompareWorkbooks and CompareWorksheets methods activate the same dialog box as is presented when the corresponding Compare commands are selected manually from the OAK user interface.  The action that follows is controlled by the data gathered by the dialog box from the user.