Hi guys, as title mentioned. Here some steps that I want to make for my bot but I don’t know the activities to use for step 3:
The folder name is created based on excel. So I want the bot read row of the excel and move the downloaded file to the folder created. Any ideas on steps no 3 ?
you can use move file the “from” path is the downloaded file, “to” path is the target folder name
That one is for static destination, mine is more like dynamic which the “destination” need to search folder based on excel
can you post your excel file here
test.xlsx (8.0 KB)
Here the attached, the bot read the A column. Then, the download file will move to folder based on A column in excel.
I can specify the path but I am trying to make dynamic destination as the folder name might change in the future based on the excel.
@Aldrin_Pro
Use move file activity to transfer the downloaded files from one folder to another folder by using the latest timestamp of the file.
Use if condition activity :
file nmes :
xyz.xlsx
abc.xlsx
Balancesheet.xlsx
if row(0) ==xyz :
move to xyz folder
else :
if row(0) ==abc
move to abc folder
else :
if row(0) ==balancesheet
move to the balancesheet folder
else :
you can apply this logic
Hope this will help you
Happy automtion
Best Regards,
Vrushali
If you just want to move file, I recommend File.Move(source file path, target file path) Method.
Also check FileInfo class.
refer
how does robot know which folder to move to? or does it download one file for each row in excel?
the bot takes the latest file from downloaded folder and transfer to folder
Ok its solved now, I found solution by using path “User PC/” + row(0).ToString
With this, it read the excel by row first and transfer to it one by one.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
Anil_G
Yoichi
yangyq10
postwick
chandreshsinh.jadeja
aravindbalineni123
Parvathy
aya
PRASHANT_GABHANE