Workbook.SetLinkOnData (Excel)

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

SetLinkOnData (Name, Procedure)

ActiveWorkbook.SetLinkOnData "WinWord|'C:\MSGFILE.DOC'!DDE_LINK1",  "my_Link_Update_Macro"

Arguments

The following argument is required

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

The following argument is optional

Procedure - 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