View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael.Tarnowski Michael.Tarnowski is offline
external usenet poster
 
Posts: 95
Default Scan directory and import file conditionaly

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 thread
http://groups.google.com/group/micro...+list ing%22#

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