Dear Tom,

Many thanks.

"Tom Ogilvy" wrote:

Look in Excel VBA help at the ChangeLink command.

--
Regards,
Tom Ogilvy


"Mark McW" wrote:

I want to use a macro to replace a link using a new file name. Can I do this
without having to clear the current linked file name.

Thanks for your help...... Mark.