topic Re: ole in Application Development and Automation Discussions

ole

Former Member — Wed, 11 Jul 2007 05:05:11 GMT

Please could any one help me out with the protection of the data send to excel sheet wth a password.That is when the data is send to excel it should not be accessable.

Re: ole

Former Member — Wed, 11 Jul 2007 05:06:57 GMT

hi,

Refer to these related threads

Re: ole

Former Member — Wed, 11 Jul 2007 06:42:37 GMT

hi,

thanks but i want to password protect a particular cell.and the above method is not working

Re: ole

Former Member — Wed, 11 Jul 2007 06:46:49 GMT

This Option Is Available In Excel and Not in SAP.

In the Excel File when You Open , Go to the Menu -- Tools --> Protection -- > Protect Sheet or Workbook whatever you want you can select.

Then It will ask for the Password, Give the Password and save it.

And again if you try to open the file or access the sheet it will ask for the password you have given.

Bye

Mohan

Re: ole

Former Member — Wed, 11 Jul 2007 06:51:24 GMT

Hi mohan,

But this is possible only after the data is filled inside the excel sheet.But my requirement is that after the file has been created as a template with password protection and then data is filled into the excel sheet.Is that possible?

Re: ole

Former Member — Wed, 11 Jul 2007 08:25:20 GMT

Yes, It is possible to edit/update the file irrespective of Password Protection.

Password Protection works based on the options you use, either one can edit, read or write in the file.

So enabling the Password Protecttion, means one can access(read/edit/update/save) the file by entering the Password.

Bye

Mohan