When you record a macro, Quattro Pro translates special keystrokes into keyboard commands. When you type in a macro, use these commands in place of keystrokes. There are four categories:
¿ Function Keys
F1 through F12
¿ Status Keys
Caps Lock, Scroll Lock, and other indicator keys
¿ Other Keys
Break, Esc, Del, plus other keys and key combinations
Keyboard commands emulate the keys of the keyboard. You can repeat many of these macro commands by specifying a repeat number as an argument. For example, to move the selector down five cells, use {DOWN 5}.
You can combine key commands for a variety of purposes. For example, the following macro replaces a formula in the active cell with its result and then moves down one cell:
{EDIT}{CALC}~{DOWN}
The following macro deletes the last three characters of whatever is in the active cell:
{EDIT}{END}{SHIFT+LEFT 3}{DEL}{CR}
For compatibility with future versions of Quattro Pro, use command equivalents to execute menu items instead of using keyboard macros.
Movement Key Macro Commands
Use these macro commands in place of arrows and other movement keys:
{HOME} Home
{END} End
{LEFT} or {L} Left arrow
{RIGHT} or {R} Right arrow
{UP} or {U} Up arrow
{DOWN} or {D} Down arrow
{PGUP} PgUp
{PGDN} PgDn
{BIGLEFT} or {BACKTAB} Ctrl+Left arrow or Shift+Tab
{BIGRIGHT} or {TAB} Ctrl+Right arrow or Tab
Function Key Macro Commands
These macro commands are equivalent to Quattro Pro function keys and key combinations:
{CALC} F9
{EDIT} F2
{FUNCTIONS} Alt+F3
{GRAPH} F11
{HELP} F1
{INSPECT} F12
{MACROS} Shift+F3
{MARK} Shift+F7
{NAME} F3
{NEXTPANE} F6
{NEXTTOPWIN} Ctrl+F6
{NEXTWIN} Shift+F6
{OBJECTSPAGEGOTO} Shift+F5
{QUERY} F7
{TABLE} F8
Status Key Macro Commands
These macro commands are equivalent to the status indicator keys:
{CAPOFF} Caps Lock off
{CAPON} Caps Lock on
{INSOFF} Ins off
{INSON} Ins on
{NUMOFF} Num Lock off
{NUMON} Num Lock on
{SCROLLOFF} Scroll Lock off
{SCROLLON} Scroll Lock on
Macro Commands for Other Keys
These macro commands are used for building key combinations and for entering or editing data:
{CLEAR} Ctrl+Backspace (Clears any existing entry from a prompt line or from the input line in Edit mode)
{CR} or ~ Enter
{DATE} Ctrl+Shift+D
{SHIFT} The keystroke Key while Shift is held down
Screen Macro Commands
These macro commands affect the display:
{BEEP}
Sounds the computer's bell.
{INDICATE}
Sets the mode indicator to display a specified string.
{PANELOFF}
Suppresses menus and prompts.
{PANELON}
Restores menus and prompts disabled by {PANELOFF}.
{WINDOWSOFF}
Prevents screen updating.
{WINDOWSON}
Restores screen updating disabled by {WINDOWSOFF}.
Screen commands can control the status line, suppress screen redraws, or sound the computer's bell. For example, {INDICATE "WAIT"} changes the status line indicator to WAIT; {INDICATE} resets the status line to its default.
Cell Macro Commands
These macro commands affect the data stored in specific cells. They can enter and read data, recalculate specific cells, or convert values into formatted labels:
{BLANK}
Erases a cell or cells.
{CONTENTS}
Copies the contents of one cell to another as a formatted label.
{GETDIRECTORYCONTENTS}
Enters an alphabetized list of files in a specified directory into specified cells.
{GETWINDOWLIST}
Lists open windows in specified cells.
{LET}
Places a number or string in the given location.
{NAVIGATE.SelectTable}
Expands selection of table boundaries.
{NAVIGATE.Zoom2Fit}
Zooms a table so that it fits in the visible part of the screen.
{NAVIGATE.GoTo}
Navigates to the sides or corners of a table.
{NAVIGATE.Jump}
Jumps to the next table in a given direction, or to the current table boundary if currently within a table.
{PUT}
Places a number or string in a given location offset by the specified number of columns and rows.
{PUTBLOCK}
Stores a value in each specified cell.
{PUTBLOCK2}
Stores Data in each cell of Block; same as {PUTBLOCK} except it parses date formats and requires a formula prefix before values.
{PUTCELL}
Stores the specified data in the active cell.
{PUTCELL2}
Stores the specified data in the active cell; same as {PUTCELL} except it parses date formats and requires a formula prefix before values.
{RECALC}
Recalculates formulas in the specified location in row-wise order for a specified number of times, or until a specified condition is reached.
{RECALCCOL}
Recalculates formulas in the specified location in column-wise order for a specified number of times, or until a specified condition is reached.
{SPEEDFILL}
Fills the selected cells with sequential data.
{SPEEDFORMAT}
Applies a standard format to the selected cells.
{SPEEDFORMAT.Add}
Adds a new format based on a specified cells.
{SPEEDFORMAT.Remove}
Removes a format.
{SPEEDSUM}
Adds filled cells in the specified cells and writes the sum in adjacent empty cells (right/bottom).
Interactive Macro Commands
Interactive commands let you create macros that accept users' input. These commands can display dialog boxes and pop-up menus, pause the macro and request input, and prevent you from breaking out of the macro during a crucial period:
{ ? }
Pauses the macro and accepts input from the keyboard until you press Enter.
{ACTIVATE}
Makes the specified window active.
{DODIALOG}
Displays the specified dialog box.
{GET}
Pauses the macro, accepts one keystroke, and stores it in the specified location.
{GETLABEL}
Pauses the macro, displays a specified prompt, and stores the subsequent keystrokes as a label in the specified location.
{GETNUMBER}
Pauses the macro, displays the specified prompt, and stores the subsequent keystrokes as a numeric value in the specified location.
{PAUSEMACRO}
Pauses the macro for dialog box entries, then resumes the macro when the user closes the dialog box.
{UNDO}
"Takes back" the last command; cancels its effects.
{WINDOW}
Makes the next pane active.
{WINDOW}
Makes the specified window active.
Program Flow Macro Commands
Program flow commands let you branch and loop in a macro. Use these commands to create macros that behave differently based on logical decisions, to break down complicated macros, or to consolidate repetitious macros into subroutines:
{DEFINE}
Defines the type of arguments passed to a subroutine and tells where to store them.
{FORBREAK}
Terminates execution of a {FOR} command.
{QUIT}
Terminates macro execution and returns keyboard control.
File Macro Commands
File macro commands work with data in files other than the active notebook. These commands can open files and read their data character by character, or create custom data files. If a file command succeeds, the macro command in the next cell is run, ignoring any other commands in the same cell as the file command. Commands in the same cell as the file command run only if the file command fails. Use this feature to trap errors such as the disk being full or reading data past the end of the file:
{ANSIREAD}
Reads the specified number of bytes and stores them in the specified location, without any character mapping.
{ANSIREADLN}
Reads a line of characters and stores it in the specified location, without any character mapping.
{ANSIWRITE}
Writes a string of characters to the current file, without any character mapping.
{ANSIWRITELN}
Writes a string of characters to the current file and ends it with a carriage return/linefeed, without any character mapping.
{CLOSE}
Closes a file opened by {OPEN}.
{FILESIZE}
Calculates the number of bytes in the current file, and stores the value in the specified location.
{GETPOS}
Places the position of the file pointer in the specified location.
{OPEN}
Opens a file for reading, writing, modifying, or appending.
{READ}
Reads the specified number of bytes and stores them in the specified location.
{READLN}
Reads a line of characters and stores it in the specified location.
{SETPOS}
Sets the file pointer to the specified byte position in a file.
{WRITE}
Writes a string of characters to the current file.
{WRITELN}
Writes a string of characters to the current file and ends it with a carriage return/linefeed.
OLE and DDE Macro Commands
OLE and DDE macro commands communicate with other Windows applications:
{DELVAR}
Deletes the specified named variable and frees any object assigned to that variable.
{EXECAUTO}
Evaluates one or more automation expressions, but drops any returned values from expressions.
{EXECUTE}
Runs the specified macro in a server application.
{POKE}
Sends data to a DDE application.
{REQUEST}
Requests data from a DDE application.
{SETLCID}
Specifies a locale ID for automation expressions.
UI Building Macro Commands
UI building commands can add or remove menu items from the active menu bar:
{ADDMENU}
Adds a menu to the menu system at a specified location.
{ADDMENUITEM}
Adds a menu item to the menu system at a specified location.
{ADDSUBMENUITEM}
Adds a menu item to the menu system at a specified location and makes the command at that location a menu.
{DELETEMENU}
Deletes a menu from the active menu system.
{DELETEMENUITEM}
Deletes a menu item from the active menu system.
{SETMENUBAR}
Sets the active menu system.
Object Macro Commands
Object commands let you move and resize objects on the Objects sheet either in a chart window, in a notebook window, or in a dialog window. These commands can also create objects or change the property settings of Quattro Pro objects. Object commands can affect objects in any Quattro Pro window.
{ADDSERIES}
Adds a data series to a floating chart.
{COLUMNWIDTH}
Sets the width of columns in the specified cells.
{CREATEOBJECT}
Creates chart or dialog objects.
{DUPLICATE}
Duplicates selected chart annotations or dialog box controls.
{FLOATCOPY}
Copies a floating object in the active notebook window.
{FLOATCREATE}
Creates a floating chart, SpeedButton, or drawn object.
{FLOATMOVE}
Moves a floating object in the active notebook window.
{FLOATSIZE}
Resizes a selected floating object in the active notebook window.
{FLOATTEXT}
Replaces the string in the selected floating text box with the specified string.
{GETOBJECTPROPERTY}
Gets property setting from an object.
{GETPROPERTY}
Gets property setting from the object currently selected.
{MOVETO}
Moves selected objects to coordinates x, y.
{RESIZE}
Resizes selected objects in the active window.
{ROWCOLSHOW}
Shows or hides rows or columns in the specified cells.
{ROWHEIGHT}
Sets the height of rows in the specified cells.
{SELECTBLOCK}
Selects a contiguous or noncontiguous selection within the active notebook.
{SELECTFLOAT}
Selects floating objects in the active notebook window using their object names.
{SELECTOBJECT}
Selects objects in active window.
{SETGRAPHATTR}
Equivalent to setting Chart Setup and Background properties (colors are comma-separated RGB triplets in quotes).
{SETOBJECTPROPERTY}
Sets properties of objects.
{SETPROPERTY}
Sets properties of selected object.
Miscellaneous Macro Commands
These commands insert characters and comments, and perform a variety of other tasks. The slide commands at the end of the list are used to build and run slide shows:
} or { } } Inserts a right brace, }
{ { } Inserts a left brace, {
{ ~ } Inserts a tilde, ~
{ } (blank) Does nothing; lets you reserve space in a macro without stopping macro execution.
{ ; } (semicolon) Lets you enter explanatory remarks in a macro.
{HLINE} Scrolls window horizontally the specified number of lines.
{HPAGE} Scrolls window horizontally the specified number of pages.
{VLINE} Scrolls window vertically the specified number of lines.
{VPAGE} Scrolls window vertically the specified number of pages.
For slide show commands, see {Slide.Option}
Command Equivalent Macros
Use the following command equivalent macros in place of menu items. When used with @COMMAND, they return current command settings.
{Align.Option}
Equivalent to Format Align.
{AnalysisExpert}
Equivalent to Tools Numeric Tools Analysis.
{Application.Property}
Equivalent to Tools Settings.
{BlockCopy}
Equivalent to Edit Copy Cells.
{BlockDelete.Option}
Equivalent to Edit Delete.
{BlockFill.Option}
Equivalent to Edit Fill Fill Series.
{BlockInsert.Option}
Equivalent to Insert Cells.
{BlockMovePages}
Equivalent to Edit Move Sheets.
{BlockName.Option}
Equivalent to Insert Cell Names.
{BlockReformat}
Equivalent to Format Text Reformat.
{BlockTranspose}
Equivalent to Tools Numeric Tools Transpose.
{BlockValues}
Equivalent to Edit Convert to Values.
{BudgetExpert}
Equivalent to Tools Numeric Tools Budget.
{ChartExpert}
Equivalent to Insert Chart.
{ClearContents}
Equivalent to Edit Clear Values.
{ClearFormats}
Equivalent to Edit Clear Formats.
{ComposeFormula}
Equivalent to clicking.
{Consolidate.Option}
Equivalent to Tools Consolidate Edit.
{ConsolidateExpert}
Equivalent to Tools Consolidate New.
{Controls.Option}
Equivalent to Format Object Order.
{DbAlias}
Equivalent to Insert External Data Aliases.
{DialogView}
Equivalent to Tools Macro Dialog Designer.
{DialogWindow.Property}
Equivalent to right-clicking the title bar of a custom dialog window.
{EditClear}
Equivalent to Edit Clear.
{EditCopy}
Equivalent to Edit Copy.
{EditCut}
Equivalent to Edit Cut.
{EditGoto}
Equivalent to Edit Go To.
{EditPaste}
Equivalent to Edit Paste.
{ExportGraphic}
Equivalent to Chart Export to File.
{FileClose}
Equivalent to File Close.
{FileCloseAll}
No equivalent command.
{FileCombine}
Equivalent to Tools Data Tools Combine Files.
{FileExit}
Equivalent to File Exit.
{FileExtract}
Equivalent to Tools Data Tools Extract to File.
{FileImport}
Equivalent to Tools Data Tools QuickColumns.
{FileNew}
Equivalent to File New.
{FileOpen}
Equivalent to File Open.
{FileRetrieve}
No equivalent command.
{FileSave}
Equivalent to File Save.
{FileSaveAll}
No equivalent command.
{FileSaveAs}
Equivalent to File Save As.
{FileSend}
Equivalent to File Send To Mail.
{FloatOrder.Option}
Equivalent to Format Object Order.
{Frequency.Option}
Equivalent to Tools Numeric Tools Frequency.
{GraphCopy}
Equivalent to Edit Paste Special.
{GraphDeactivate}
No equivalent command.
{GraphDelete}
Equivalent to Chart Delete Chart.
{GraphEdit}
Equivalent to right-clicking and clicking Edit Chart.
{GraphGallery}
Equivalent to Chart Gallery.
{GraphNew}
Equivalent to Chart New Chart.
{GraphSettings.Titles}
Equivalent to Chart Titles.
{GraphSettings.Type}
Equivalent to Chart Type/Layout.
{GraphView}
Equivalent to Chart View Chart.
{GraphWindow.Property}
Equivalent to right-clicking the title bar of a chart window.
{Group.Option}
Equivalent to Insert Name Groups of Sheets.
{GroupObjects}
Equivalent to Format Group.
{ImportGraphic}
Equivalent to Insert Graphics Clipart.
{InsertBreak}
Equivalent to Insert Page Break.
{InsertObject}
Equivalent to Insert Object.
{Invert.Option}
Equivalent to Tools Numeric Tools Invert.
{Links.Option}
Equivalent to Edit Links.
{MapExpert}
Equivalent to Insert Graphics Map.
{Multiply.Option}
Equivalent to Tools Numeric Tools Multiply.
{NamedStyle.Option}
Equivalent to Format Styles.
{Notebook.Property}
Equivalent to Format Notebook.
{Notebook.Summary.Option}
Equivalent to File Properties.
{ObjectsPageGoto}
Equivalent to View Objects Sheet.
{OLE.Option}
Equivalent to right-clicking an OLE object and clicking the Property command.
{Optimizer.Option}
Equivalent to Tools Numeric Tools Optimizer.
{Order.Option}
Equivalent to Format Object Order.
{Page.Property}
Equivalent to Format Sheet.
{Parse.Option}
Equivalent to Tools Data Tools QuickColumns.
{PasteFormat}
Equivalent to Edit Paste Special.
{PasteLink}
Equivalent to Edit Paste Special.
{PasteSpecial}
Equivalent to Edit Paste Special.
{PlayPerfectScript}
Equivalent to Tools Macro Play.
{Preview}
Equivalent to File Print Preview.
{Print.Option}
Equivalent to File Page Setup.
{PrinterSetup}
Equivalent to File Print, then specifying a printer.
{Query.Option}
Equivalent to Tools Data Tools Notebook Query.
{Regression.Option}
Equivalent to Tools Numeric Tools Regression.
{ResizeToSame}
Equivalent to Format ResizeToSame.
{RestrictInput.Option}
No equivalent command.
{Scenario.Option}
Equivalent to Tools Scenario Edit.
{ScenarioExpert}
Equivalent to Tools Scenario New.
{Search.Option}
Equivalent to Edit Find And Replace.
{SelectAll}
Equivalent to Edit Select All.
{Series.Option}
Equivalent to Chart Series.
{SeriesManager.Option}
Equivalent to Edit Define QuickFill; Series.
{Slide.Run}
Equivalent to Slides Play Slide Show.
{SlideShowExpert}
Equivalent to Tools Slide Show New.
{SolveFor.Option}
Equivalent to Tools Numeric Tools Solve For.
{Sort.Option}
Equivalent to Tools Sort.
{TableQuery.Option}
Equivalent to Insert External Data Table Query.
{TableLink.Option}
Equivalent to Insert External Data Table Link.
{TableView}
Equivalent to Insert External Data Database Desktop.
{Toolbar.Option}
Equivalent to View Toolbars.
{UngroupObjects}
Equivalent to Format Ungroup.
{WhatIf.Option}
Equivalent to Tools Numeric Tools What-If.
{WhatIfExpert}
Equivalent to Tools Numeric Tools What-If.
{WindowArrIcon}
Equivalent to Window Arrange Icons.
{WindowCascade}
Equivalent to Window Cascade.
{WindowClose}
Equivalent to Control Menu Close.
{WindowHide}
Equivalent to Window Hide.
{WindowMaximize}
Equivalent to Control Menu Maximize.
{WindowMinimize}
Equivalent to Control Menu Minimize.
{WindowMove}
Equivalent to Control Menu Move.
{WindowNewView}
Equivalent to Window New View.
{WindowNext}
Equivalent to Control Menu Next.
{WindowPanes}
Equivalent to View Split Window.
{WindowQPW.Option}
Equivalent to Quattro Pro Control Menu.
{WindowRestore}
Equivalent to Control Menu Restore.
{WindowShow}
Equivalent to Window Show.
{WindowSize}
Equivalent to Control Menu Size.
{WindowTile}
Equivalent to Window Tile.
{WindowTitles}
Equivalent to View Locked Titles.
{WorkSpace.Option}
Equivalent to File Workspace.
Analysis Tools Macro Commands
Analysis Tools commands let you perform analyses of numerical data. They are equivalent to the tools available when you choose Tools Numeric Tools Analysis.
{ANOVA1}
One-way analysis of variance.
{ANOVA2}
Two-way analysis of variance with replication.
{ANOVA3}
Two-way analysis of variance without replication.
{DESCR}
Creates a table of descriptive statistics that characterize one or more samples.
{EXPON}
Exponentially smooths a series of values.
{FOURIER}
Performs a fast Fourier transformation on cells of data.
{FTESTV}
Performs a two-sample F-Test to compare population variances.
{HISTOGRAM}
Calculates the probability and cumulative distributions for a sample based on a series of bins.
{MCORREL}
Returns the correlation matrix between two or more data sets.
{MCOVAR}
Returns the covariance matrix between two or more data sets.
{MOVEAVG}
Returns a moving average for the values in a sample.
{MTGAMT}
Generates an amortization schedule for a mortgage.
{MTGREFI}
Generates a table of information relating to refinancing a mortgage.
{PTTESTM}
Performs a paired two-sample Student's t-Test for means.
{PTTESTV}
Performs a Student's t-Test using two independent samples with unequal variances.
{RANDOM}
Returns random values from a specified distribution.
{RANKPERC}
Computes the ordinal and percent rank of each value in a sample.
{REGRESS}
Performs multiple linear regression analysis.
{SAMPLE}
Returns a periodic or random sample of values from cells.
Quattro Pro DOS Compatible Commands
This command or menu equivalent is provided for compatibility with the DOS version of Quattro Pro. To learn more about it, see the Quattro Pro for DOS @Functions and Macros guide.
