copy / rename / move

[anees420]

need some help copying and deleting files

here is what i would like the macro to do

1. go into a specific folder (c:\downloads)

2. copy the most current xls file that starts with asap-files and has a xls extension to c:\temp\working_asap.xls (specific name)

4. delete the rest of the xls files in c:\downloads that start with asap-files and has a xls extension

5. loop it every 180 seconds

i have a software witch downloads xls files every 30 seconds and i need to move the most current file and delete the rest of the xls files


Thank you all

 

[jbeaucaire]

This thread shows you how to evaluate the files in a folder for the most recent.

http://www.mrexcel.com/forum/showthread.php?t=223730

Couple that code with a use of the VBA Name function to basically move the file found to another directory.

Then delete all .xls files in the folder.

 

[anees420]

thanks for the link but that did not help me... i tried the marco and get

run-time error 1004

 

[jbeaucaire]

Post up your edited version of that macro so we can see what you're trying. Give us any other specifics that help us understand your version.