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
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