Links to Word doc - automatically updating filename?

[Bobblybook]

Hi everyone,
I've got a pair of files (xls + doc) where fields & graphs are linked into the word doc. The problem is I have the template files, but if I copy them to use for a report, the fields in the new word doc still link to the template file rather than it's own version of the spreadsheet.

The word doc and excel files will have the same name apart from the file extension... would it be possible to make the links in word dynamic? I haven't really explained it that well.. here's an example:

Currently I have template.xls and template.doc. If I make a copy of both and rename them reportA.xls and reportA.doc, the fields in reportA.doc still reference template.xls rather than reportA.xls.
Would it be possible to make links within the word doc such as [own filename without .doc].xls rather than just a static link to a specific file? I will have reportB, reportC etc. and I need each one to reference it's own excel spreadsheet.

If not is there any other way of dealing with this problem?

Thanks,
Adam

 

[Bobblybook]

Nobody has any ideas?

 

[Bobblybook]

I can't seem to find a way to edit my post unfortunately, but I have found a command in excel which returns the filename of the excel file: =cell("filename")
I basically need this functionality in word if possible in order to set the references to the linked charts/objects to this filename.