_Application.DDEExecute Method

  • Article

Runs a command or performs some other action or actions in another application by way of the specified DDE channel.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub DDEExecute ( _
    Channel As Integer, _
    String As String _
)
'Usage
Dim instance As _Application
Dim Channel As Integer
Dim String As String

instance.DDEExecute(Channel, String)

void DDEExecute(
    int Channel,
    string String
)

Parameters

  • String
    Type: System.String

    Required String. The message defined in the receiving application.

Remarks

The DDEExecute method is designed to send commands to another application. You can also use it to send keystrokes to another application, although the SendKeys method is the preferred way to send keystrokes. The String argument can specify any single key combined with ALT, CTRL, or SHIFT, or any combination of those keys. Each key is represented by one or more characters, such as "a" for the character a, or "{ENTER}" for the ENTER key.

To specify characters that aren't displayed when you press the corresponding key (for example, ENTER or TAB), use the codes listed in the following table. Each code in the table represents one key on the keyboard.

Key

Code

BACKSPACE

{BACKSPACE} or {BS}

BREAK

{BREAK}

CAPS LOCK

{CAPSLOCK}

CLEAR

{CLEAR}

DELETE or DEL

{DELETE} or {DEL}

DOWN ARROW

{DOWN}

END

{END}

ENTER

~ (tilde)

ENTER (numeric keypad)

{ENTER}

ESC

{ESCAPE} or {ESC}

F1 through F15

{F1} through {F15}

HELP

{HELP}

HOME

{HOME}

INS

{INSERT}

LEFT ARROW

{LEFT}

NUM LOCK

{NUMLOCK}

PAGE DOWN

{PGDN}

PAGE UP

{PGUP}

RETURN

{RETURN}

RIGHT ARROW

{RIGHT}

SCROLL LOCK

{SCROLLLOCK}

TAB

{TAB}

UP ARROW

{UP}

You can also specify keys combined with SHIFT and/or CTRL and/or ALT. To specify a key combined with one or more of the keys just mentioned, use the following table.

To combine a key with

Precede the key code with

SHIFT

+ (plus sign)

CTRL

^ (caret)

ALT

% (percent sign)

See Also

Reference

_Application Interface

_Application Members

Microsoft.Office.Interop.Excel Namespace