I
Ian Elliott
I have a workbook with a macro (code at the end of this
message) where I copy sheets from another workbook into
this one.
To change the formulas in the worksheets I copied to
values, I am breaking the links through Edit>Links...
However, for some reason I cannot break a few of the
workbook links.
The ones I can break, after I highlight the file, and
click on Break Link, the file disappears.
But for the ones I can't, even though I click on the file,
and then click on Break Link, the file still stays there,
under Source, Type, Update, and Status.
Can anyone maybe tell me why? Appreciate all the help,
thanks.
Workbooks.Open FileName:="\\blah\blah.xls", UpdateLinks:=0
Worksheets("Sheet1").Copy after:=ThisWorkbook.Sheets
("Balance")
Sheets("Balance").Delete
Worksheets("Sheet1").Name = "Balance"
Workbooks("blah.xls").Close savechanges:=False
message) where I copy sheets from another workbook into
this one.
To change the formulas in the worksheets I copied to
values, I am breaking the links through Edit>Links...
However, for some reason I cannot break a few of the
workbook links.
The ones I can break, after I highlight the file, and
click on Break Link, the file disappears.
But for the ones I can't, even though I click on the file,
and then click on Break Link, the file still stays there,
under Source, Type, Update, and Status.
Can anyone maybe tell me why? Appreciate all the help,
thanks.
Workbooks.Open FileName:="\\blah\blah.xls", UpdateLinks:=0
Worksheets("Sheet1").Copy after:=ThisWorkbook.Sheets
("Balance")
Sheets("Balance").Delete
Worksheets("Sheet1").Name = "Balance"
Workbooks("blah.xls").Close savechanges:=False