IOAKAddIn

VBA API for OAK, using the user interface.

Applies to

The Operis_OAK object library

Enumerations

OAKResult  A code indicating the success or otherwise of an OAK user interface call.

Methods

AnalyzeDiscrepancies: Activates the Analyze Discrepancies user interface.

ApplyNames: Activates the Apply Names user interface.

BuildNameDatabase: Activates the Build Name Database user interface.

CompareWorkbooks: Activates the Compare Workbooks user interface.

CompareWorksheets: Activates the Compare Worksheets user interface.

CompareRanges: Activates the Compare Ranges user interface.

CopyAddress: Activates the Copy Address user interface.

CopyLiteral: Activates the Copy Literal user interface.

DeapplyNames: Activates DeApply Names user interface.

Delete: Activates the Delete Rows/Columns user interface.

DeleteNamesInCells: Activates the Delete Names in Cells user interface.

GetVersion: Gets the current version of OAK.

Insert: Activates the Insert Rows/Columns user interface.

LocalizeNamesInCells: Activates the Localize Names in Cells user interface.

Map: Activates the Map Workbook user interface.

Optimize: Activates the Formula Optimize user interface.

Prune: Activates the Pruner user interface.

Reconstruct: Activates the Formula Reconstruct user interface.

RecreateNames: Activates the Recreate Names user interface.

RedefineName: Activates the Redefine Name user interface.

RemoveColorFormatting: Activates the Remove Color Formatting user interface.

RemoveHashREFNames  Activates the Remove #REF! Names user interface

SearchFor: Activates the Search user interface

SearchForArrays: Activates the Search for Arrays user interface.

SearchConstantFormula: Activates the Search for Constant Formulas user interface.

SearchForHardwiredConstant: Activates the Search for Hardwired Constants user interface.

SearchForMerged: Activates the Search for Merged Cells user interface.

SearchForPrimaryError: Activates the Search for Primary Error Cells user interface.

SearchForReferenceToBlankCells: Activates the Search for References to Blank Cells user interface.

SearchForUnreferencedCells: Activates the Search for Unreferenced Cells user interface.

SearchForValue: Activates the Search for Unreferenced Cells user interface.

Summarize: Activates the Summarize Workbooks/Worksheets user interface.

Transpose: Activates the Transpose user interface.

WorksheetManager: Activates the Worksheet Manager.

UndoCompareModifications: Activates the Undo Compare Modifications user interface.

UnhideCells: Activates the Unhide Cells user interface

Properties

ExcelApplication: The Excel application object.  This must be set before any of the functions will work.

See also

Getting started in scripting