For Each FIle In Folder -Change PDF Name with vallue from excel?

Help StudioX
1

I have made a robot that uses an excel file do googel and download an pdf file.

the problem: I want to change the name of each downloaded pdf file with an ID Number from my excel file.

What activity can I use for this after the For Each File In Folder activity ?

Result should be: ID1.pdf , ID2.pdf

2

@Nils_Berns

While downloading did you get a popup to save as and write the path of the file?

image
image1436Ă—977 61 KB

Then use a Type Into activity and in File Name give entire path of the folder with the file name which you want

If the Save As Popup not enable then configure your browser to Always ask for download option to enable, so that it will not download automatically

Hope this helps you

Thanks

1 Like
3

I will try this , thanks.

4

It works half way.

When I use type Into and select the excel column the robots uses thes same field ( doesn´t move downwards to the next field)

An Idea how to fix that?

OK found it , had tu use current row

Thanks for the help!

5

@Nils_Berns

Place TypeInto in For Each row activity, so when the loop changes the typeInto activity also changes

In TypeInto give as row(“Columnname”).ToString

Hope this helps you

Thanks

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.