We have over a thousand Excel workbooks that we have to move to a new server as part as an upgrade. Each of these workbooks have vLookup links in them to another shared workbook.
Now that these workbooks have moved, this link location is now wrong. can a script be developed to open each of these workbooks and change the source of these links to the new location. all the workbooks are in the same folder, and the source is the same in each as well.
current location is \\serverA\jobs\...... new location is \\serverB\jobs\.....
as a furher complication, this same link location is used inside a vba module in each of these workbooks. it is not as important to update these, but it would be nice.