Is there some code that someone could give me that I could put as a sub routine in another macro to check that links to other spreadsheets are correct?
I have a master set of around 700 workbooks all of which are copied once a year to a new directory. I have one big macro that does all of this and it works fine.
In the filepath for each link is a specific word FY05REPS. Ideally I would like the macro to search through the links in each workbook and if it doesn't find this word in every one to either stop or preferably send a message with the file name for me to write down and then go back and correct when the macro had fisnished running.
Thanks in advance
Tim.