Compare file names to folder contents

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Hi-

In an Excel file I have a column of PDF file names; e.g., aaA.pdf;
AbC.pdf; 123.pdf. The -actual- PDFs should be in a folder on my
desktop. I'd like a way to compare the list of file names to the folder
contents to verify that the PDFs are in fact in my desktop folder.

For each file name in the Excel doc, can a macro search for a matching
PDF file in my desktop folder and place a "yes" or "no" in the adjacent
column?

Thank you!


--
marlea
------------------------------------------------------------------------
marlea's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26209
View this thread: http://www.excelforum.com/showthread.php?threadid=522891

.

Quantcast