Thanks Guessed.
That is what I do currently but its a bit long winded as a workaround.
I would ideally like to make an idiot proof link tool that others can also use.
I know there must be some code that I can use to make the re-linking of excel a straightforward process without potential for syntax errors.
Cheers,
John.