Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Link Source
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Link Source | Excel Discussion (Misc queries) | |||
Can Change (link) Source take hours? | Excel Discussion (Misc queries) | |||
How change link source in long formula when source moved | Excel Programming | |||
Change Source of Link in Protected Sheet | Excel Discussion (Misc queries) | |||
How to change the source of a link- Instructions were followed. I. | Excel Worksheet Functions |