Name
workbook
.SetLinkOnData(Name
, [Procedure
])
Synopsis
Sets a procedure to run whenever a DDE link is updated.
Argument |
Settings |
---|---|
|
The name of the OLE or DDE link as returned by the |
|
The name of a procedure to run when the link is updated |
The following code sets the OnUpate
procedure to run whenever a DDE link is updated within the workbook:
linkSources = ThisWorkbook.linkSources(xlOLELinks) If IsArray(linkSources) Then For Each link In linkSources If InStr(1, link, "DDE") Then _ ThisWorkbook.SetLinkOnData link, "OnUpdate( )" Next End If
Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.