![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Board Regular
Join Date: Feb 2002
Location: Singapore
Posts: 77
|
This problem prompted to me for a long time.
I have several files which are referenced by one file. My problem is that, after i renamed the referenced files as a new set of files, i need to go to "Edit->Links" to change sources(since the referenced file names and path are changed) one by one. I have tried to record Macro to change the link sources but it doesn't work. Could anyone help me? Thank in advance. Here to Learn XJ [ This Message was edited by: Andrew XJ on 2002-02-27 05:17 ] |
|
|
|
|
|
#2 |
|
Board Regular
Join Date: Feb 2002
Location: Singapore
Posts: 77
|
Any one have done that before?
I'll appreciate for you response |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|