Show TOC

Syntax documentationEvMNU Locate this document in the navigation structure

The EvMNU (menu) function allows you to create links that launch menu tasks, modules, or run macros. You use these functions in custom menus and for adding custom buttons to reports and input schedules (see Custom Menu Functions and List of Menu Commands for a complete reference of menu commands).

Syntax Syntax

EvMNU(MacroName,DisplayName,Parameter)

MacroName — The name of the macro you want to use. The system provides several custom macros that contain the prefix MNU. You can also use the following macro commands in addition to the MNU menu commands:

  • OPENFILE — Opens a workbook. Defaults to the /Webfolders//eExcel directory, unless a full path is defined.

  • CLOSEEXCEL — Shuts down Microsoft Excel.

  • OPENWEBFOLDER — Opens the named Web folder.

  • SETCV — Sets the CurrentView. An example of a current view is as follows:

    EvMNU(SETCV,,ENTITY=SalesUS;TIME=2008.JAN)

    You can string multiple EvMNU functions together using the & operator. For example, you can set the current view for a file you are opening as follows: EvMNU("SETCV",,"Category=actual;time=2003.Q4;")& ("openfile","Click Here","filename.xls"). .

DisplayName — The text the user selects to launch the menu task.

Parameter — The macro parameter. Most macros require information, such as file names or member names, to function. This is where you define that information.

End of the code.

Example Example

The following example returns the Stats member in the cell. If you double-click Stats within the workbook, the Member Lookup dialog box is displayed. You can select another member to display in that cell.

=EVMBR("FINANCE","Stats")

End of the example.