search directory, list files containing certain txt

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.