Automating Macro Execution
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:
- Set the HypUseLinkMacro flag to false.
- Connect the sheet and retrieve a grid.
- Select a data point on the sheet.
- Run the macro that contains all the function calls to initialize the grid and set the connection, row, column, and POV items.