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