Move, Rename all files from a folder

Hi,

I have a folder which is constantly updated with files every 5 minutes and the naming convention is fairly complex and unnecessary but I cannot change it.

Basically I need a macro to automatically move all files from this folder 'C:\Test1' to another folder 'C:\Test2', rename the moved files based on most recently added, most recently added being '1.csv' and open up each of these .csv files on a different sheet in an active workbook. After this has completed the files in 'C:\Test2' will be deleted.

I have been at this for hours and cannot do it so any help is much appreciated.

Regards,
David

See if this does what you want.

Please Login or Register  to view this content.

Call Import_Files() using Application.OnTime if you want it to run every 5 minutes.

Chippy, You hero. Cheers mate