Search found 8 matches

by DSTP
Mon Aug 17, 2015 7:23 pm
Forum: General Discussion
Topic: Copying files using excel speadsheet
Replies: 2
Views: 12059

Re: Copying files using excel speadsheet

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...
by DSTP
Mon Aug 17, 2015 5:09 pm
Forum: General Discussion
Topic: Copying files using excel speadsheet
Replies: 2
Views: 12059

Copying files using excel speadsheet

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 poin...
by DSTP
Thu Apr 30, 2015 11:34 pm
Forum: General Discussion
Topic: Renaming Files Automation
Replies: 11
Views: 45843

Re: Renaming Files Automation

Thanks for the helping me with this, however it's not changed any of the file names. I've changed the base folder to the folder containing the images. Imported task. Run the program. It finds the excel file. Program runs through process. Finished with no errors. No file names have changed. Please he...
by DSTP
Thu Apr 30, 2015 4:15 pm
Forum: General Discussion
Topic: Renaming Files Automation
Replies: 11
Views: 45843

Re: Renaming Files Automation

Cheers for writing the code.

Where would I place the edited code and how would I get it started.
by DSTP
Thu Apr 30, 2015 2:47 pm
Forum: General Discussion
Topic: Renaming Files Automation
Replies: 11
Views: 45843

Re: Renaming Files Automation

Thats correct.
by DSTP
Thu Apr 30, 2015 2:29 pm
Forum: General Discussion
Topic: Renaming Files Automation
Replies: 11
Views: 45843

Re: Renaming Files Automation

Zipped it!
by DSTP
Thu Apr 30, 2015 2:04 pm
Forum: General Discussion
Topic: Renaming Files Automation
Replies: 11
Views: 45843

Re: Renaming Files Automation

If you could create a small example that would be appreciated..

The forum won't allow me to upload xls files, could you send me an email address

Cheers
by DSTP
Thu Apr 30, 2015 12:53 pm
Forum: General Discussion
Topic: Renaming Files Automation
Replies: 11
Views: 45843

Renaming Files Automation

I'm wanting to automate a process of renaming approx 9000 files. The new & old file names are stored in a excel spreadsheet and I'd like robotask to find old file name and rename the relevant file from the spreadsheet. Is this possible? How would I go about doing this, I'm kinda computer savvy b...