how to change source of all excel pasted links in word doc at once

B

Bender

I have many pasted links from an excel file into a word file. I need to be
able to reuse many documents for many different projects of the same type.
After resaving both files as new files, I've figured out how to change the
source for each link, but you can only do one at a time. Is there a way to
change all of them at once?
Also is there any way to associate one word file with one excel file as one
"project" or something so that they open together and associate themselves as
one?

Thanks,
Bender
 
M

macropod

Hi Bender,

Press Alt-F9 to expose the link coding, then use Find/Replace to change the
link paths/filenames, then Alt-F9 to restore the fields.

You may also need to tell Word to update the links, which you can do via
Ctrl-A (to select the whole document), then F9 (to update all fields).

No vba required. If you're after a vba solution, check out my Field Link
Updater, at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=261488

Cheers
 
Top