Automating Macro Execution

You can automate execution of a macro through the Oracle Smart View for Office menu.

To set up a macro to execute manually through the Smart View menu:

  1. Set the HypUseLinkMacro flag to false.
  2. Connect the sheet and retrieve a grid.
  3. Select a data point on the sheet.
  4. Run the macro that contains all the function calls to initialize the grid and set the connection, row, column, and POV items.