1. Developer's Guide
  2. About VBA Functions
  3. Using Spreadsheet Toolkit VBA Applications in Smart View

Using Spreadsheet Toolkit VBA Applications in Smart View

Describes using the spreadsheet toolkit VBA applications in Oracle Smart View for Office.

VBA applications created in Oracle Hyperion Essbase Spreadsheet Toolkit can be converted to Smart View by making the following modifications:

  • Replace the EssV prefix of Spreadsheet Toolkit functions with Hyp; for example, change EssVRemoveOnly to HypRemoveOnly.

  • Replace the EssMenuV prefix of Spreadsheet Toolkit menu functions with HypMenuV; for example, change EssMenuVZoomIn to HypMenuVZoomIn.

  • Replace the declarations in essxlvba.txt with the declarations in smartview.bas.