Compare filenames listed in Excel to external folder.

[Chayes]

I’m hoping someone can help with a solution.

In column A I have a list of filenames in the form 12345.JPG.

I’d like to be able to run a macro and enter a folder name in a message box to check if each of the files named in column A exists in the folder entered in the message box. It would then report ‘present’ or ‘not present’ against each item.

For example

A

123.JPG
124.JPG
125.JPG
195.JPG
203.JPG
12356.JPG

Would be compared to the contents of the folder named in the message box , and might report back


A B

123.JPG Present
124. JPG Present


125.JPG Present
195. JPG Not Present
203. JPG Not Present
12356.JPG Present

Change of colours would help for ‘Present’ or ‘Not Present’ maybe.


Grateful for any help.