Data Loader Keystrokes

In Forms Data Loader you can send keystrokes to the target application by entering "\" as the starting character. FDL recognizes a cell as a keystroke if the cell contains a backslash "\" in the first position.

For example, to send the ALT and F keystroke, enter \%f; to send "ALT-FV" enter \%fv.

To specify characters that aren't displayed when you press a key, such as ENTER or TAB, and keys that represent actions rather than characters, use the codes shown below:

Key	Code
BACKSPACE	`\{BACKSPACE}`, `\{BS}`, or `\{BKSP}`
BREAK	`\{BREAK}`
CAPS LOCK	`\{CAPSLOCK}`
DEL or DELETE	`\{DELETE}` or `\{DEL}`
DOWN ARROW	`\{DOWN}`
END	`\{END}`
ENTER	`\{ENTER}` or `~`
ESC	`\{ESC}`
HELP	`\{HELP}`
HOME	`\{HOME}`
INS or INSERT	`\{INSERT}` or `\{INS}`
LEFT ARROW	`\{LEFT}`
NUM LOCK	`\{NUMLOCK}`
PAGE DOWN	`\{PGDN}`
PAGE UP	`\{PGUP}`
PRINT SCREEN	`\{PRTSC}`
RIGHT ARROW	`\{RIGHT}`
SCROLL LOCK	`\{SCROLLLOCK}`
TAB	`\{TAB}`
UP ARROW	`\{UP}`
F1 – F16	`\{F1}` … `\{F16}`

To specify keys combined with any combination of SHIFT, CTRL, and ALT, precede the key code with one or more of the following codes:

Key	Code
SHIFT	`+`
CTRL	`^`
ALT	`%`

To specify that any combination of SHIFT, CTRL, and ALT should be held down while several other keys are pressed, enclose the code for those keys in parentheses. For example, to hold down SHIFT while E and C are pressed, use \+(EC). To hold down SHIFT while E is pressed, followed by C without SHIFT, use \+EC.

To specify repeating keys, use the form {key number}. You must put a space between key and number. For example, \{LEFT 42} means press the LEFT ARROW key 42 times; \{h 10} means press H 10 times.

Mouse Clicks

Code What it does

Code	What it does
`MC(x,y)` or `ML(x,y)`	If you enter `MC(x,y)` in a cell, it tells FDL to simulate a mouse click in the target application while loading. X means X-screen coordinate and Y means Y-screen coordinate. For example, entering `MC(430,240)` makes FDL simulate a mouse left click on the screen at the 430,240 coordinate while loading. To capture exact coordinates, use our Get Screen Coordinate Tool from the Tools menu.
`*MR(x,y)`	If you enter `MR(x,y)` in a cell, it tells FDL to simulate a right mouse click in the target application while loading. X means X-screen coordinate and Y means Y-screen coordinate. For example, entering `MR(530,440)` makes FDL simulate a mouse right click on the screen at the 530,440 coordinate while loading.

*MC(x,y)
or
*ML(x,y)

If you enter *MC(x,y) in a cell, it tells FDL to simulate a mouse click in the target application while loading. X means X-screen coordinate and Y means Y-screen coordinate.

For example, entering *MC(430,240) makes FDL simulate a mouse left click on the screen at the 430,240 coordinate while loading.

To capture exact coordinates, use our Get Screen Coordinate Tool from the Tools menu.

*MR(x,y)

If you enter *MR(x,y) in a cell, it tells FDL to simulate a right mouse click in the target application while loading. X means X-screen coordinate and Y means Y-screen coordinate.

For example, entering *MR(530,440) makes FDL simulate a mouse right click on the screen at the 530,440 coordinate while loading.

The Forms Data Loader Macro Recording feature will automatically record the keystrokes and mouse clicks as you enter data into a form.

Please click the "Create New by Macro Recording" button on the toolbar to start Macro Recording. For more information click here.

Not using Forms Data Loader? Download it from here.