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????????

two ways,

1st - open all workbook and SAVE AS with the new name.

2nd - copy the files rename, open and EDIT LINKS, change the source

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"rlh3" escreveu:

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????????