How to put the file in specific path and rename it

  1. Open file in Google Chrome - row “Link” in excel.
  2. Click Download
  3. Put the path from row “Document” in excel
  4. Rename it using row " Rename" in excel

See files below,

image

To get the latest file from the downloaded folder, you can use the below code.

Directory.GetFiles(folder_path,“.xlsx”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Tolist(0)

After getting this you can use Move file activity, to paste at desired location.

@prititit

Use Read Range activity to read your excel file-> Output to Datatable Variable
Use For Each Row to loop into your datatable
Use Open Browser activity inside For Each Row activity and give URL as row(“Link”).ToString
Once opened then choose click download as you said using click activity
Once you click on dowload button SaveAs Dialog box appears
Use TypeInto activity to write into Filename textbox as row(“Document”).ToString +""+row(“Rename”).ToString
This will save your file into the given path as in Excel file

Hope this may help you

Thanks

Hello @srini84 -

That’s actually what I did and it’s working. The problem is even though the ocndition that I put in the empty field is true, it’s not typing the path. if the before path is too long

@prititit

Also you can try to use Set Text and try

Thanks