SetLinkOnData Method

         Example         Applies To

Sets the name of a procedure that runs whenever a DDE link is updated.

Syntax

expression.SetLinkOnData(Name, Procedure)

expression   Required. An expression that returns a Workbook object.

Name   Required String. The name of the DDE/OLE link, as returned from the LinkSources method.

Procedure   Required String. 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.