RoboTask forum

Hi Oleg,

I'm currently stuck on a little project.

I'm wanting to transfer files from one folder to another using excel with a list of codes, I've tried recording a macro for the whole process:

click excel spreadsheet
press enter
Ctrl+C
Click Folder
Click Search Bar
Ctrl+V
Move to Object

At this point it crashes each time, I've changed from icons, to list and even details.

Secondly I've tried building the task:

Open Excel File

However I don't know how to select a cell in the tasks and use this information to find a file from a folder and copy to new folder.

Please help.

Thanks in advance.


Excel File location: C:\Users\Home\Pictures\New folder\Pams Image List
Old File Location: C:\Users\Home\Dropbox\Pams Images
New File Location: C:\Users\Home\Pictures\New folder\

I've managed to build a task, but struggling to use the data in excel.

I: 17/08/2015 19:19:13: Executing "5.Excel Get Cells"
W: 17/08/2015 19:19:13: (2) OLE error 800A03EC
E: 17/08/2015 19:19:13: OLE error 800A03EC
E: 17/08/2015 19:19:13: An error occurred. Step #5 (Excel Get Cells).
E: 17/08/2015 19:19:13: Task execution is aborted

Task as is now:

Excel Open Document
Create Local Variable "ROW" with value "1"
While Loop
Increment Variable "row"
Excel Get Cells
If Then
Copy move File
End If
End Loop

Unfortunately I can say nothing without your task and your Excel document
Also send the full log file of the task.

Pack these files and send the to me to oleg(at)robotask.com