title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
Workbook.SetLinkOnData method (Excel) |
vbaxl10.chm199151 |
|
|
b500a579-6e4c-5712-05cf-27c6393b3bcd |
05/29/2019 |
medium |
Sets the name of a procedure that runs whenever a DDE link is updated.
expression.SetLinkOnData (Name, Procedure)
expression A variable that represents a Workbook object.
Name | Required/Optional | Data type | Description |
---|---|---|---|
Name | Required | String | The name of the DDE/OLE link, as returned from the LinkSources method. |
Procedure | Optional | Variant | The name of the procedure to be run when the link is updated. This can be either a Microsoft Excel 4.0 macro or a Visual Basic procedure. Set this argument to an empty string ("") to indicate that no procedure should run when the link is updated. |
This example sets the name of the procedure that runs whenever the DDE link is updated.
ActiveWorkbook.SetLinkOnData _
"WinWord|'C:\MSGFILE.DOC'!DDE_LINK1", _
"my_Link_Update_Macro"
[!includeSupport and feedback]