Workbook.SetLinkOnData Method (Excel)
Sets the name of a procedure that runs whenever a DDE link is updated.
Syntax
expression .SetLinkOnData(Name, Procedure)
expression A variable that represents a Workbook object.
Parameters
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. |
Example
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"