replace links in files on a share

Question

The issue is that we are moving a share within our company to a different box. I need a program that would go through the files (for example excel files), and update the links in that file to point to the new location. Example: an excel file will have a link like \\servername\sharename$\filename that I would need changed to \\newserver\newshare$\filename. But this program will have to also deal with other filetypes that contain links on the share. I am open to any suggestions that anyone may have. Has anyone done something like this before and what worked out for you. Thanks in advance.