Modify file import macro to skip previously imported files.

Hello, the code below imports all the excel files in the folder it is saved in. I use this to create a database containing those files. Is it possible to modify this code to only import the files that is has not previously imported?

Thanks!

Please Login or Register  to view this content.

Hi
try the modified macro it adds files (& data ) which is not present in col A
Ravi

That worked perfectly! This is the second time you have helped me! Thanks again!

Clayton