Command Overview

The save command is used to store commands on a worksheet permanently for future re-use. The command supports only the worksheet as a data source.

Syntax

The command is entered on the command line as the command name ("sc") followed by one or more command parameters. Each command parameter consists of an argument name, immediately followed by an equal sign ("=") and then immediately followed by a value. The value may be enclosed with quotation marks, and must be enclosed by quotation marks if the value consists of any embedded spaces.

An example of a command parameter to specify that the file name to be processed is test.txt is entered as "file=test.txt" (without the quotations). Each argument on the command line must consist of only valid parameter names. If a required parameter name is missing, then the command line will be colored yellow, an error message will be displayed on the Excel status bar and an audible tone will be sounded.

The following is a listing of all parameter values for the save command:

The command syntax varies depending upon whether the commands are stored on a worksheet or in the toolbar. There are four possibilities:

Store worksheet entries to the registry:

In the toolbar, specify the processing parameters required, which are the name of the sheet where the commands are stored, the name of the command group, the upper left hand corner of the area to be stored and the name of the column which contains the commands. All of the commands will be stored under the name specified, starting with the first command entry and going down the area until a blank row is encountered.

An example of the command is shown below:

sc name=ben sheet=Commands ulc=a9 col=Command

 Store toolbar entries to the registry group specified

sc name=testcmd

Store toolbar entries to a worksheet

sc sheet=Sheetname ulc=a2

(specification of upper left corner is optional, and defaults to a1 if not specified)

Store toolbar entries to a file

sc file=filename

 if the filename contains embedded spaces the name must be enclosed in quotation marks, e.g. sc file=”c:\program files\ezs\xlac\testcmd.txt”

An example

The command to save the commands on a worksheet named "Text" with the sheet area having an upper left hand corner in cell "b9" and having a column named "command" to a registry group named "ben" is as follows:

sc sheet=Text ulc=b9 col=command name=ben

Output from the processing will store the command group into the registry entry specified

Main Form