I'm trying to unpin a few defunct workbooks from a model, but im having to open lots and lots of files up just to check on the off chance if they're linked to the ones im culling. Would it be possible for a macro to open each file in the directory, check to see if it references anywhere workbook i want to remove (say "0405data.xls") and list the workbooks that do and the relevant worksheets within them where the references are? If that's a little optimistic just a yes or no to if it contains any reference to my file could suffice.
If it's a complex task, then I'll do it manually, but it just might save me a few hours on a monday morning if anyone can help. Ta.
Bookmarks