To declare all Smart View VBA functions, in Excel Visual Basic Editor import smartview.bas, located by default in EPM_ORACLE_HOME/smartview/bin into a module. Then you can use any Smart View Excel VBA function in your program. You can delete any declarations that you do not need.
To declare individual Smart View VBA functions, enter the appropriate declarations fromsmartview.bas, using descriptions from VBA Functions