Show TOC

Function documentationMenu Commands Locate this document in the navigation structure

 

Menu commands are custom functions that can be used in VBA or within the Excel function EvMNU(). Most of them begin with MNU_. The EvMNU() function is an actionable Excel formula that is used within an Excel workbook, reports, or input schedules. These functions can be used for a variety of tasks such as to open other reports or input schedules, show the current view settings for dimensions, or link to Web content and documents. An EvMNU function is a click action in a worksheet cell that may require more user input.

EvMNU Syntax

EvMNU(MacroName,DisplayName,Parameter)

Where:

  • MacroName is the menu command provided with Planning and Consolidation, for example, OPENFILE, SETCV, and MNU_eSUBMIT.

  • DisplayName is the text the user clicks to launch the menu task. The display name is optional.

  • Parameter is the macro parameter. Some macros require information, such as file names or member names in order to function properly.

Examples:

  • Set a current view to a specific member for specified dimensions. There is no display name in this example.

    EvMNU(“SETCV”,,”ENTITY=SalesUS;TIME=2004.JAN”)

  • Create a hyper link named Analysis that opens the A01Entity.xls workbook:

    EvMNU("OPENFILE","Analysis",,"/REPORTS/WIZARD/Reports/Wizard/Local/Analysis/A01Entity.xlt")

  • String multiple EvMNU functions together using the & operator. You can set the current view for a file you are opening like this:

    =EVMNU("SETCV",,"CATEGORY=PLAN;TIME=2005.Q4")&EVMNU("OPENFILE","open file","/REPORTS/WIZARD/Local/Analysis/A01Entity.xlt")

Most Planning and Consolidation commands begin with the prefix MNU_. However, the following commands are also available:

  • OPENFILE

    Opens a local file.

    Defaults to the “C:\Documents and Settings\<Local user>\My Documents\PC_NW\<Logon user>\AppInfo\<appset>\<app>\eExcel” directory, unless a full path is defined.

    EvMNU(OPENFILE,”optional text”,{path})

    For example, evMNU(“OPENFILE”,,"c:/Documents and Settings/<Local user>/My Documents/PC_NW/<Logon user>/AppInfo/<appset>/<app>/eExcel")

  • CLOSEEXCEL

    Shuts down Microsoft Excel.

    EvMNU(CLOSEEXCEL,,)

  • OPENWEBFOLDER

    Opens the /<appset/<app>/eExcel folder. You cannot change the default path.

    EvMNU(OPENWEBFOLDER,”optional text”)

  • SETCV

    Sets the current view.

    EvMNU(SETCV,,dimension=member)