IOAKAPI

VBA API for OAK, bypassing the user interface.

Applies to

The Operis_OAK object library

Methods

AnalyzeDiscrepancies: Produces a discrepancy analysis of the specified cells.

ApplyNames: Applies the specified names to the specified range.

BuildNameDatabase: Builds a database of the names in a workbook.

Compare:  Compare workbooks or worksheets, using the user's default colors.

CompareRanges:  Compare ranges, using the user's default colors.

CompareRangesWithColors: Compare ranges, specifying colors.

CompareWithColors: Compare workbooks or worksheets, specifying colors.

CopyLiteral: Copies the formula(s) from the source range to the target range, preserving relative references.

DeapplyNames: Deapplies the specified names to objects in the specified scope.

Delete: Activates the Delete Rows/Columns user interface.

DeleteNamesInCells: Activates the Delete Names in Cells user interface.

FormatAddress: Formats the address of a specified range.

GetVersion: Gets the current version of OAK.

Insert: Activates the Insert Rows/Columns user interface.

LocalizeNamesInCells: Localizes the names listed in the specified range.

Map: Produces a map of the specified workbook or worksheets.

Optimize: Activates the Optimizer user interface.

Prune: Activates the Pruner user interface.

Reconstruct: Reconstructs a range to a specified depth, and generates a report workbook

Reformulate:  Gives access to the technologies underpining reconstruction, denaming and formula simplification.

RecreateNames: Renames adjacent blocks of cells to new names from text on an edge of the range, removing the existing names and remapping references to them.

RedefineName: Changes the name and/or value of the specified name, if necessary removing the existing names and remapping references to them.

RemoveColorFormatting: Removes the color formatting from the specified workbook or worksheets.

RemoveHashREFNames:  Removes names whose definitions have acquired #REF! components.

SearchForArrays: Selects cells within the specified range that contain array formulas or array constants.

SearchConstantFormula: Selects cells within the specified range that contain constant formulas.

SearchForHardwiredConstant: Selects cells within the specified range that contain hardwired constants.

SearchForMerged: Selects cells within the specified range that contain merged cells.

SearchForPrimaryError: Selects cells within the specified range that are the origins of errors on the worksheet.

SearchForReferenceToBlankCells: Selects cells within the specified range that contain formulas that refer to blank cells.

SearchForUnreferencedCells: Selects cells within the specified range that are not referred to in any formulas.

SearchForValue: Selects cells within the specified range that contain cells with a range of values.

ShowProgress: Specify if user-interface progress indicators should be shown during API calls.

Summarize: Summarize a workbook or worksheets.

Transpose: Transposes the source range, optionally to the target range, while preserving addresses and removing name references.

UndoCompareModifications: Undoes any modifications made to the specified workbook or worksheets by previous OAK comparison actions.

UnhideCells: Exposes cells within the specified range that lie on hidden rows or columns.

Properties

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