I have a folder which contains 4 sub-folders and within these sub-folders
there are 2, 30, 2 and 3 workbooks.
The folder is named "wk", I copy this folder and then rename it "wk1",
"wk2", "wk3" etc.
There are links throughout this folder and when it is renamed some of the
links are updated to reflect the name change and others don't change. I then
have to highlight the problem cells and use the "replace" function to change
"wk" to "wk1" etc.
Can anyone shed some light on this for me