LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ActiveWorkbook.BreakLink runs but doesn't work?! WhytheQ Excel Programming 0 June 28th 09 01:00 PM
Need urgent help with VBA 2007 CHARTWIZARD method !!! rAJU_sR Excel Programming 2 June 24th 08 05:54 AM
problems using printout method in excel 2007 lieven Excel Programming 0 June 22nd 07 09:06 AM
BreakLink steve Excel Programming 8 September 15th 06 09:37 PM
Why these commands make erros? (Breaklink and SaveAs) pauloreiss[_4_] Excel Programming 1 January 5th 06 03:53 AM


All times are GMT +1. The time now is 08:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"