Macro and Command File Functions

 

#DEFAULT

Restore default macros

#DEFINE

Define a macro

#INCLUDE

Include macro files in other macro files

#UNDEFALL

Clear all macros

#UNDEFINE

Clear a macro

__CALLER__

Returns the name of the caller SPL routine

__CALLERFILE__

Returns the full path to the caller SPL routine

__CALLERFILENAME__

Returns the file name portion of the caller SPL routine

__FILE__

Returns the full path to the current SPL routine

__FILENAME__

Returns the file name portion of the current SPL routine

__FUNC__

Returns the name of the current SPL routine

__LINE__

Returns the current line number in the current SPL routine

; (Semicolon)

Combine several functions, commands, or macros on a single line for execution as a whole. This command form may be used at the command line or within a macro

| (Vertbar)

Combine several functions, commands, or macros on a single line for execution as a whole. This command form may be used at the command line or within a macro (deprecated - use ; )

ALLMACROS

Display all macros

CALL

Call a command file N times

CLEAR

Clear a macro

COMFILESTATUS

Return the execution status of a command file

COMMAND FILE FUNCTIONS

Execute a command file function

COMMAND FILE KEYSTROKES

Represent non-standard keystrokes

COMMANDS

Display list of commands available at worksheet level

DEFMACRO

Define macro string or scalar constant

DSPMACREAD

Read macro definitions from file in the MACROS folder

DSPMACVIEW

View an ASCII text file from the MACROS folder

EVAL

Evaluate string expression

EVALTOSTR

Evaluate to a string

FUNCS

Display list of available functions

GETMACRO

Return information about a macro

ISMACRO

Determine whether a macro is defined

JUMP

Jump to a label in a macro

LOAD

Load a command file

MACREAD

Read an external file of macro definitions

MACROS

List current macros defined in worksheet

MACWRITE

Write current macro list to an external file

MESSAGELOG

Write status line messages to text file

NOP

Perform no operation

OFF

Macro returning integer 0

ON

Macro returning integer 1

RESETMACROS

Clear all user define macros but preserves system macros.

SETMACDEPTH

Set maximum depth for nesting macros

UNDEFALLMACROS

Clear all macros

UNDEFMACRO

Clear a macro

VIEWFILE

Display contents of ASCII file