LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
import picture taken data from my pictures directory into excell? John VanNierop Excel Discussion (Misc queries) 7 July 6th 10 01:03 PM
file save error: the file or directory cannot be created dublg Excel Discussion (Misc queries) 1 September 25th 06 07:07 PM
How do I stop automatic virus scan when I open powerpoint file? EdV Excel Discussion (Misc queries) 1 June 27th 06 06:57 PM
Excel should let me sort the file directory when saving a file Beanee70 Excel Discussion (Misc queries) 0 March 14th 06 07:03 AM
How do I turn off virus scan on opening an Excel file? Bowler Excel Discussion (Misc queries) 2 February 4th 06 02:40 AM


All times are GMT +1. The time now is 11:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"