Copy File based on modification date

[Clay]

Hello,

I would like to be able to copy a file from 1 folder to another folder based on the modification date.

The files I want to copy will either be .xls, or .xlsx and will have different names each time the task is ran, which will be every 1/2 to 1 hour time intervals throughout the day.


Could you please advice on how I can accomplish this task.

Thank you,

Clay

[forumsupport]

Hello Clay,

Please try below mentioned steps:

1 Start Loop " Each File in C:\AA"
2 If File date ("$CurrentDirectory$\$FileName$.$Extension$" modified date is in last 30 minutes) Then
3 Excel : Open Spreadsheet "$CurrentDirectory$\$FileName$.$Extension$". Active Sheet: Default. Session: Default
4 Pause
5 Excel : Close Spreadsheet . Session: Default
6 End If
7 End Loop

By using “Loop for Each file in a folder” command along with the use of Excel commands and series of system variables, the task will run for all the files (.xls or .xlsx) in the folder.

Hope it matches with your requirements.