I am trying to read data from a cell in Excel, store that as a string, and then name a file so that the file name is that string. How can I do this?
@scott.luntz Considering you already have the string stored in variable, You can use the Move File Activity to rename the File. It also Depends on the Path where you need to store it, also you would have to append it’s extension to the file name.
How should I structure the move file activity so that it maintains a path such as “C:_RPA” and then adds the variable to the end?
Can you please show the accurate workflow? Thanks
@scott.luntz This Workflow should be enough for you to understand the renaming process. If you still need more info, Please ask about the same.
Rename File.zip (7.7 KB)
Firstly check the “New Folder” and “Renamed Folder”. “New Folder” contains a file that I would want to rename it and push it to a different folder. After you have Executed the workflow. The File in “New Folder” will be present in “Renamed Folder” as “MyText.txt” as “MyText” was the value present in the Excel.
Hello Scott,
In this video I do a lot of stuff with Files (Chapter included) :
1:10 Download the file and Move the latest file to folders
4:30 Rename files with VB commands
6:00 Move files to do Rename
6:55 Delete files
8:15 Delete only PNG files
8:55 Delete all the files except PNG files
9:55 Move files
11:10 Delete files that are older than 2 weeks
14:40 Create a file or folder with dates inside
17:00 Trigger a process when the file is added to a folder
18:45 How to use the files start the process
20:30 Excel Application Scope use files
Thanks,
Cristian Negulescu