R
rlh3
I have a group of workbooks that are linked. Within each workbook are
worksheets that are also linked to other worksheets in the home workbook as
well as to the other workbooks.
The workbooks are filed in a folder named 2007. Each workbook is identified
by a filename that contains the year. I want to copy the workbooks to a 2008
folder and rename them with the current year. The problem comes from the
fact that all of the links need to be changed. Is there a way to do this
automatically, or am I stuck with the original filenames????????
worksheets that are also linked to other worksheets in the home workbook as
well as to the other workbooks.
The workbooks are filed in a folder named 2007. Each workbook is identified
by a filename that contains the year. I want to copy the workbooks to a 2008
folder and rename them with the current year. The problem comes from the
fact that all of the links need to be changed. Is there a way to do this
automatically, or am I stuck with the original filenames????????