This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

protect excel workbook

Question
0

Sign in to vote

Hi,

I have to passward protect an XLS file via powershell.

how can i do so?

thanks in advance!

Sunday, January 21, 2018 4:14 PM

All replies

0

Sign in to vote
Have you tried to search for an answer?

https://blogs.technet.microsoft.com/heyscriptingguy/2005/02/07/how-can-i-password-protect-an-excel-spreadsheet/
\_(ツ)_/
- Proposed as answer by Albert LingMicrosoft contingent staff Friday, January 26, 2018 2:14 AM
Sunday, January 21, 2018 4:17 PM
0

Sign in to vote
yes,

of course i searched for an answer.

any way i finally found the mistake.

when using passward it is also needed to fill the file format as well.

$excel.saveas(path , file format, passward)
- Proposed as answer by Albert LingMicrosoft contingent staff Friday, January 26, 2018 2:14 AM
Thursday, January 25, 2018 4:41 PM
0

Sign in to vote

Hi,

Good to hear that you have solved this issue by yourself. In addition, thanks for sharing your solution in the forum as it would be helpful to anyone who encounters similar issues.

If there is anything else we can do for you, please feel free to post in the forum.

Best Regards,
Albert
Please remember to mark the replies as an answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

Friday, January 26, 2018 2:14 AM