PC Review


Reply
Thread Tools Rate Thread

Break links VBA

 
 
New Member
Join Date: Jun 2008
Posts: 6
 
      16th Jun 2008
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:52 AM.