Hi,
I have to provide password for an already existing excel, If password is already existing let it be … orelse we have to make that excel as password protected… How can I implement this using Invoke code in UiPath.Anyone can you please help to sort it out…PaswordProtected.zip (1.9 KB)
@Chippy_Kolot ,
Follow this thread for how to check if password is already there for the file or not.
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.
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.
@Chippy_Kolot ,
Here you go sample code
Sample Code: PaswordProtected.zip (129.4 KB)
system
February 6, 2025, 2:22pm
4
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
