Preventing off retrieve data multiple times

Hello everybody,

Current program i use follows these steps:

-Empty cells

-Remove comments

- Fill Headers

- Retrieve Data (From the path Results (a subdirectory))

- Sort on date and time (column D)

My Problem: The programma now used retrieves every file in the subdirectory again and again.
If it has like 100-200 files it takes a very long time.

Is it possible to make a function for this that only retrieves files when the filename is not imported already? (Title is in the D Column)

Wish: a function that retrieves only the required data and skips measuring data thats already there.

few concepts:
a. add checking if the filename is already in column D (easy to do with COUNTIF) and open only if not
b. make small change to name as file is retieved (for instance oldfilename_RET.oldextension)
c. move file with retrieved data to another location (subfolder?)

any of this will require ingerention in program. (proposition c. can be easily done also manually or written as a shell script in your operating system)

Originally Posted by Kaper

few concepts:
a. add checking if the filename is already in column D (easy to do with COUNTIF) and open only if not
b. make small change to name as file is retieved (for instance oldfilename_RET.oldextension)
c. move file with retrieved data to another location (subfolder?)

any of this will require ingerention in program. (proposition c. can be easily done also manually or written as a shell script in your operating system)

Heres my code

Please Login or Register  to view this content.

Don't really know where to put the countif file, anyone that knows where to use it? Thanx in Advance