Workbook.BreakLink Method

Syntax

expression.BreakLink(Name, Type)

expression A variable that represents a Workbook object.

Parameters

Example

In this example, Microsoft Excel converts the first link (an Excel link type) in the active workbook. This example assumes at least one formula exists in the active workbook that links to another Excel source.

Sub UseBreakLink() Dim astrLinks As Variant ' Define variable as an Excel link type. astrLinks = ActiveWorkbook.LinkSources(Type:=xlLinkTypeExcelLinks) ' Break the first link in the active workbook. ActiveWorkbook.BreakLink _ Name:=astrLinks(1), _ Type:=xlLinkTypeExcelLinks End Sub

See also:

• Workbook Object
• Workbook Object Members