Utilities menu

Custom menu items can be created to easily run script files, command syntax files, or other applications. You can add an item to an existing menu, or create an entire menu of your own.

step From the menus choose:

Utilities
 Menu Editor

In this dialog box you can create entire menus, add items to existing menus, insert seperators between menu items, or delete menus or menu items.

Use the Apply To list to select the Window to which your menu item or menu will be added.

step Double-click the Utilities menu item to expand it.

step Select Run &Script and click Insert Item.

step Type Send to Excel as the new item's name.

The default menu item type is application, although you can also create menu items that run a script or a syntax file.

step Select XLS - Excel Files from the Send Data As Type list. The next few steps require that you have Microsoft Excel installed on your system.

step Click Browse and navigate to the Excel executable file, Excel.exe. Typically, this file is located in C:\Program Files\Microsoft Office\Office.

step Select the file and click Open.

Now, when you select this menu item, the data in the Data Editor is sent to an Excel spreadsheet.

step Click OK to save your changes and close the Menu Editor dialog box.

To use your new menu item, you first need to open a data file.

step From the menus choose:

File
 Open
  Data

step Navigate to and open demo.sav.

step From the menus choose:

Utilities
 Send to Excel

After you make the menu selection, Microsoft Excel opens and displays the data from the Data Editor.