How to make excel as password protected

[ashokkarale]

@Chippy_Kolot,

Follow this thread for how to check if password is already there for the file or not.

How to detect if an Excel file is password-protected

My customer gets Excel files from the business, some of them are password-protected even if they shouldn’t. In that case, the goal is to detect this and generates an error report, otherwise the robot is blocked. Consequently I would like to detect if an Excel file is password-protected before trying to read it. I found this post: Check whether excel is password protected? But it does not work because the robot is blocked as soon as the “Use Excel File” activity executes. In fact, I have a “Exc…

For adding password to excel file, refer this thread which uses VBA to password protect the file.

How to set protection to excel file

Hello Anjani, I had the same issue and the solution I came up with was to create a VBA script and call it: Excel_ProtectSheet.xaml (6.7 KB) ProtectSheet.txt (123 Bytes) Unfortunately the .vbs filetype was not allowed to be uploaded, so change the .txt to .vbs and you should be good to go.

How to put password on excel fileand make it password protected

Hi TUSHAR_DIWASE, Please check this activity in marketplace. [image] [image] Cheers!