DDEUNLINK

Purpose:

Ends a previous DDELINK operation.

Syntax:

DDEUNLINK("app", "topic", "item")

DDEUNLINK("app|topic!item")

"app"

-

A string, the application name.

"topic"

-

A string, the topic name.

"item"

-

A string, the item of the conversation to end.

Returns:

A 1 if successful; otherwise it returns 0 indicating an error.

Example:

ddelink("Excel", "Sheet1", "R1C1:R100C1")

 

perform other operations ...

 

ddeunlink("Excel", "Sheet1", "R1C1:R100C1")

 

establishes a DDE conversation with Excel, returns the value of the cells in row 1, column 1 through row 100 column 1 as a series in the current window. Whenever a cell changes, the new series is appended to the existing series. Lastly, the link is terminated.

Remarks:

The "app", "topic" and "item" strings can also be placed in one string of the following Syntax: "app|topic!item". For example:

 

DDEUNLINK("Excel|Sheet1!R1C1:R100C1")

See Also:

DDEADVISE

DDEGETDATA

DDELINK