Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Workbook.SetLinkOnData Method

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

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

Namespace:  Microsoft.Office.Tools.Excel
Assemblies:   Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
'Declaration
Sub SetLinkOnData ( _
	Name As String, _
	Procedure As Object _
)

Parameters

Name
Type: System.String

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

Procedure
Type: System.Object

The name of the procedure to be run when the link is updated. This can be either a Microsoft Office 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.

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.