I haven't used the BreakLink method.
However, reviewing BreakLink in the help file reveals that "Name" should
refer to the name of the link. Also, the LinkSources method for a workbook
returns an array of all of the link names in the workbook...
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Don" <BRNER2@AOLDOTCOM
wrote in message
Background...Win XP...Xcel 2002....WB1 stores data on WS "DATA",
reports and charts are generated on quarterly WS's then saved off to
new individual WB's...
the link should be broken to the original WB but this is where the
program halts with this msg..
"Run-time error '1004'
Method 'Breaklink' of Object'_Workbook' Failed"
The code below....
'-snip-
' and next is where I want to break the link to the original WB1

ActiveWorkbook.BreakLink Name:= "C:\************\LEADS _
PROGRAM 2007-2008.xls", Type:= xlExcelLinks
ActiveWindow.Close

Any help would be greatly appreciated,
Don