Copy Sheet Activity Asking Password

[aliaga (Ali Aga Mustofa)]

Hello,

I have little problem here,
first i have sequence to copy sheet from workbook A to workbook B with name sheet changed.
i’ve set password to excel scope sequence. but if i run it, it ask password to be input.
Screenshoot :

Sequence :

could you help me, in which step i missed?
thank you

[Shubham_Varshney]

Hi @aliaga

Try the following link… Hope this helps you

Problem with Password Protected Excel file

Hello @Rahul_S, In the below link , you can get the sample project. Regards Balamurugan.S

[HareeshMR (Hareesh Madasi)]

Can you check if it is passing null value to the activitiy @aliaga? I think it is passing null value

[aliaga (Ali Aga Mustofa)]

Hi @Shubham_Varshney

it help me, but the File Path field has to fill with full link of its path (D:.…\source\Template.xlsx)

my excel filepath directory in folder RPA (source\Template.xlsx)

could you help my what ive to fill in Filepath field, full link of directory or other option?
NB : if i fill (source\Template.xlsx) the robot will return error :

Thanks

[aliaga (Ali Aga Mustofa)]

Hi @HareeshMR,
ive check using WriteLine sequence but all value are OK, include password excell and namesheet.

SS :

[Shubham_Varshney]

I think you will need to do a full path for this !!!

Do a shift + right click on the file and click on copy as path and post it there

[aliaga (Ali Aga Mustofa)]

Hi @Shubham_Varshney,

its okay i have to fill it with full path, i will store it in D:\

Thank you