Forum Discussion
Solved
Excel file encrypt with password thru Office Scripts
Hi all, I'm trying to automate adding a password to open an Excel file thru Office Scripts but it's being very difficult to me! I can do it with macros (VBA) but because the password must be adde...
- I'm afraid the answer is a simple blunt no, cannot be done. Office script cannot "handle files" in any way. It only works on the current document but cannot change things like the document name or encryption.
I'm afraid the answer is a simple blunt no, cannot be done. Office script cannot "handle files" in any way. It only works on the current document but cannot change things like the document name or encryption.
JKPieterse thats what I was afraid of... 😥 Gotta think outside the box now... If anyone knows of any way to password encrypt (or decrypt) an Excel file thru power automate I'll be really appreciated! Thanks again for your time and help!
- I'd already seen that one, unfortunately it has to be power automate cloud! 😥 I've done an automation on sharepoint/power automate to automatically send some emails with some files, but my company now is enforcing that the Excel files sent to emails outside our organization must be encrypted with password! The purpose was to encrypt the files, send the emails and then decrypt the files again. But I think it will not be possible...
