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.