SetLinkOnData Method 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"