Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BreakLink method for 2007
I have several workbooks in Excel 2003 that use the BreakLink method as
follows: Worksheets(1).Calculate ActiveWorkbook.BreakLink Name:="S:\Financial Analysis\Labor Report2.xls", Type:= _ xlExcelLinks ActiveWorkbook.Save My machine was just upgraded to Excel 2007 and VBA no longer supports the BreakLink method. Can anyone provide a workaround for the above that will work in 2007? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveWorkbook.BreakLink runs but doesn't work?! | Excel Programming | |||
Need urgent help with VBA 2007 CHARTWIZARD method !!! | Excel Programming | |||
problems using printout method in excel 2007 | Excel Programming | |||
BreakLink | Excel Programming | |||
Why these commands make erros? (Breaklink and SaveAs) | Excel Programming |