Export (0) Print
Expand All

Workbook.BreakLink Method

Office 2007
Converts formulas linked to other Microsoft Excel sources or OLE sources to values.

Syntax

expression.BreakLink(Name, Type)

expression   A variable that represents a Workbook object.

Parameters

NameRequired/OptionalData TypeDescription
NameRequiredStringThe name of the link.
TypeRequiredXlLinkTypeThe type of link.

Example

In this example, Microsoft Excel converts the first link (an Excel link type) in the active workbook.

Bb209716.vs_note(en-us,office.12).gif  Note
This example assumes at least one formula exists in the active workbook that links to another Excel source.
Visual Basic for Applications
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



Community Additions

ADD
Show:
© 2014 Microsoft