Hello :-)

Recently, we bought a new server for our company's
network, and moved all our files over from the old one to
the new one. In order for all of our old files created
with a specific word macro to work, a line must be changed
from \\oldserver\old folder1\oldfolder2\ to
\\newserver\new folder1\new folder2\

Instead of manually going into each of these several
hundred files, opening up the visual basic editor, and
changing them manually, is there a way to either:

1. run a macro on microsoft word every time it opens that
looks at the file when it is opened and If path ==
\\oldserver, then change to \\newserver or something like
that

2. run a windows script or program that looks at all the
excel files in a given folder, and looks at the visual
basic code. If it finds a certain line of code, change it
to the correct line of code.

Is there anything out there like this? I tried to search
the web but I wasn't really sure what it was called that I
needed so I didn't have much luck.

Thanks, Alex