ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   renaming problem (https://www.excelbanter.com/excel-worksheet-functions/28503-renaming-problem.html)

CAMBUSBOY

renaming problem
 
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


All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com