Changing links in many excel files.
 

Please help. I have 100's of excel files with links in formulas throughout
each sheet. All of these files reside on a server that the IT department is
moving. I am in need of some code to open each file and change all formulas
to point to the new location.