I have created a project, divided into several works, by this work are subdivided into several subfolders.
In total there are 16 Excel sheets made into these subfolders. My Excel sheets are: Basic Journal, more and less work, Set Items, Terms and solong.
These pages all refer to the basic file via hyperlink or sum, some pages also refer themselves to each other, for example, the data from more and less work are also on the sheet Terms.

It is therefore the intention that I can separate work in the sheets and that the data are made to the relevant sheets are processed.
The default folder where I've made everything works perfectly, until I copy the default folder for the next new project.
Of course I change the name of the copymap to work "testmap" and then enter the data in the base leaf.
If I for example, the sheet more and less work open a screen popsup and says: This workbook contains one or more links that can not be updated. click on links if you edit the source to change the value again or want to update. You can change the source and the testmap where the Excel sheets are then to be linked. This message he gives to each page I want to open in the testmap.
The links are refer to C: \ Documents and Settings \ Rob \ My Documents \ project \ Basic project \ 1PROJECT ADMINISTRATION \ A1 BASIC PROJECT DATA SHEET
instead of
C: \ Documents and Settings \ Rob \ My Documents \ project \ Testmap \ 1PROJECT ADMINISTRATION \ A1 BASIC PROJECT DATA SHEET

In short, the source file are not automatically adjusted after the copy of the root to a new project. For all this to each page link is too much work for an automated idea, the blades are 16 where some times linked 3 / should be modified.
Just for clarity, Excel sheets (16 pieces) are not in an Excel file.

Has anybody a solution? a vba code? I have no experience with vba codes


Regards
Robert