| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
New Member
Join Date: Jun 2008
Posts: 6
|
Excel - question
I have a file that a macro copies a few sheets out of and breaks link. I want to write some code that will break the link rather than hard code.So far I have x = ActiveWorkbook.Path y = ActiveWorkbook.Name z = x + y ActiveWorkbook.BreakLink Name:= _ x, Type:=xlExcelLinks However I can not get it to work, I have also tried X in "". Only second post and apologies for basic question 
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Break links | Robert | Microsoft Excel Discussion | 1 | 5th Apr 2008 01:02 PM |
| Help to Break links please!! | =?Utf-8?B?ZXdhbjcyNzk=?= | Microsoft Excel Programming | 3 | 20th Aug 2007 04:12 PM |
| Break Links | =?Utf-8?B?U2Vhbg==?= | Microsoft Excel Misc | 1 | 25th Oct 2006 03:34 PM |
| Break Links | =?Utf-8?B?SmF6eg==?= | Microsoft Excel Setup | 1 | 3rd Mar 2004 02:14 AM |
| why can't break links? | Ian Elliott | Microsoft Excel Misc | 1 | 29th Jul 2003 01:08 AM |
