Thread: Compare file names to folder contents
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
marlea[_14_] marlea[_14_] is offline
external usenet poster
  
Posts: 1
Default Compare file names to folder contents

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 m
desktop. I'd like a way to compare the list of file names to the folde
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 matchin
PDF file in my desktop folder and place a "yes" or "no" in the adjacen
column?

Thank you

--
marle
-----------------------------------------------------------------------
marlea's Profile: http://www.excelforum.com/member.php...fo&userid=2620
View this thread: http://www.excelforum.com/showthread.php?threadid=52289

Reply With QuoteReply With Quote