search directory, list files containing certain txt

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.

Hi

Try this. It assumes that you are in the directory that contains the files you want to check.

Please Login or Register  to view this content.

rylo

Originally Posted by rylo

Hi

Try this. It assumes that you are in the directory that contains the files you want to check.

Please Login or Register  to view this content.

rylo

Thanks for your effort Rylo, but I have my confused head on again this morning, too much beer over the weekend. Where do I enter the 'link' I'm wanting the macro to search for? Or does it assume its checking the file for links to the workbook it's being run from? I tried to play around and try it either way, but I keep getting no results.

Hi

What that code will do is open all the files in the directory, and if they have links to any other files, the filename and the link reference will be put into sheet1 of the workbook containing the macro.

Once this has completed, you can search in the link references for any of the files you are chasing.

rylo

Originally Posted by rylo

Hi

What that code will do is open all the files in the directory, and if they have links to any other files, the filename and the link reference will be put into sheet1 of the workbook containing the macro.

Once this has completed, you can search in the link references for any of the files you are chasing.

rylo

First class, that should keep me going!! Many thanks.