I've writtne code like what you want hundreds of timjes before. there arre
so many combinations of ways to do this that I need more information. That
is why I asked for the following information in my last posting

1) How many Foldes are you looking to search?
2) Do you want to also search the sub folders?
3) Where do you want the new files to be put? Below the present list or
someplace else in your workbook.


"Michael.Tarnowski" wrote:

On Mar 26, 1:27 am, "Michael.Tarnowski" wrote:
Hi excel gurus,

I regulary scan certain directories to import (=append) new files -
depending on file type (*.doc) - in a worksheet. I'am looking for a
function which scans a directory and appends only these files which
are not in the worksheet where in row A the file name and in row B the
directory name should be stored.
In the group I found the threadhttp://groups.google.com/group/microsoft.public.excel.worksheet.funct...

Does anybody have an idea how to change the VBA function mentioned in
this posting?
Thanks in advance
Michael

Nobody no idea????
Michael