PC Review


Reply
Thread Tools Rate Thread

Change Link Source

 
 
=?Utf-8?B?QW1pdA==?=
Guest
Posts: n/a
 
      24th Jan 2007
I want a macro to change linksource.

I have two excel Workbooks (say Wkb1 & Wkb2) linked to a different
application software. I have made another workbbok (say "Main Wkb") which
has the values used in Wkb 1 & 2. Wkb1 & Wkb2 are externally linked to Main
Wkb. I have presently all three in same folder.

Let current directory is "C:\A" for all the workbooks. Now, application
saves Wkb1 & Wkb2 in "C:\B". I will paste "Main Wkb" in "C:\B" manually.
Then, I want a macro which should change the link source of "C:\A\Wkb1" &
"C:\Wkb2" from "C:\A\Main Wkb" to "C:\B\Main Wkb"

Please HELP!!!!!!
 
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
Change Link Source Mike H. Microsoft Excel Misc 0 20th Jan 2010 10:38 PM
Link source - Need change? Jac Tremblay Microsoft Excel Programming 0 23rd Sep 2008 05:31 PM
Re: Can Change (link) Source take hours? Dave Peterson Microsoft Excel Misc 1 17th Jan 2007 08:58 PM
How change link source in long formula when source moved =?Utf-8?B?SXJpbmE=?= Microsoft Excel Programming 4 28th Jun 2006 07:27 AM
How to change the source of a link- Instructions were followed. I. =?Utf-8?B?Uko=?= Microsoft Excel Worksheet Functions 2 17th Dec 2004 06:59 PM


Features
 

Advertising
 

Newsgroups
 


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