Protecd excel with pwd


#1

how to write value to protected excel with Excel application scope.readOnly.xlsx (14.5 KB)
the pwd is “123”


#2

when i input the pwd in password property,the written charts can’t be saved


#3

can anyone help me?
urgent!


#4

Hi @chen,

you can refer

Excel Password.zip (163.9 KB)

Regards,
Arivu


Readrange password not working for xls file
#5


can you tell me what the password represents?①or②or both


#6

Hey @chen

Hey can look into the attached sample, its working fine, did not faced any issues with that. - Excel Password Sample.xaml (5.5 KB)
Excel Password Sample.zip (11.8 KB)

One more point wanna mention why you are using a custom activity to save your workbook.
From latest Excel Package Update you will get an option of autosave in Excel Application scope Properties.(and i can see in your screenshot, u are using that ). :slight_smile:

Regards…!!
Aksh


#7

readOnly4.xlsx (8.5 KB)
IS it impossible to use execute macro in excel application scope?
it’s important foe me ,looking forward to your reply


#8

It is possible. Check out exists threads on forum. There are plenty of topics are available with such information.

Regards…!!


#9

can you give me a sample with the excel(readOnly4.xlsx) above,pwd is 123


#10

and write something in cell.i can’t write anything in it with excel application scope.
looking forward to your reply.


#11

That file should be macro enabled to execute a macro inside that. the extension of the file will be .xlsm @chen


#12

readOnly.zip (16.2 KB)
promt that you should input password like this:
popup


#13

could anyone help me.it’s very important.