Match file names listed in column with file names in folder
 

Hi all, In Sheet("Data").column A I have file names like (see below)
523688
523699 - pg1
523699 - pg2
523689 - 523690
523711

I want macro which should match names of files which are in folder "C:
\Document" with names of files which are in Sheet("Data").column A and
if there is any file name which is in folder "C:\Document" don’t match
with the list of file names in Sheet("Data").column A then macro
should open that file and copy cell B1 and paste it in Sheet
("Data").column B cells and then close that file and then loop this
process until there is no file left in folder. Please can any friend
can help.

Match file names listed in column with file names in folder
 

This should get you started:
http://www.rondebruin.nl/folder.htm

Regards,
Ryan---

--
RyGuy


"K" wrote:

Hi all, In Sheet("Data").column A I have file names like (see below)
523688
523699 - pg1
523699 - pg2
523689 - 523690
523711

I want macro which should match names of files which are in folder "C:
\Document" with names of files which are in Sheet("Data").column A and
if there is any file name which is in folder "C:\Document" dont match
with the list of file names in Sheet("Data").column A then macro
should open that file and copy cell B1 and paste it in Sheet
("Data").column B cells and then close that file and then loop this
process until there is no file left in folder. Please can any friend
can help.