Is there a way to password protect multiple excel files or just files in general for that matter?

Need a utility or script to password protect 300 excel files which are located in 300 separate folders on a network drive.
The reason being if someone accidentally emails any of these files they would be protected.

We do have email encryption already, but this would be for the case when a file is accidentally thought to be non-sensitive and emailed in the clear, but actually it is sensitive.
This way we have peace of mind that those files are protected.

Someone can sit and do all 300 using Excel, but I was thinking somebody out there had to make a utility by now for this... like Folder Guard (which didn't work).
The protection has to stay with the file and the files are stored on a Microsoft 2012 server.

Thanks!
M.
diablo-26Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

infotechelgCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dean ChafeeIT/InfoSec ManagerCommented:
You could use a combination of ForFiles and 7zip (or equivalent)  to compress each file and set a password. This would protect the files, but they would be .7z or .zip or whatever compress you choose to use. it would look something like this:

forfiles /s /p <root path> /m *.xlsx /c "cmd /c 7z a -sdel -p <password> @fname.zip @path"

Problem is that each file would have to be uncompressed (with the password) in order to open it again on the local network. That may or may not work for you.

Regards
0
Bharat BhushanSolution ManagerCommented:
Same password for all files?
0
diablo-26Author Commented:
Yes we're thinking same password for all files, and people do work with these files and upload them to a web portal after quality checking, so probably the Excel password would be best.   I know this might be weak protection, but it's really just to protect them from the average person if one should accidentally get emailed out of the office.   It's just so someone can't just open them freely.

I did find a program called AxCrypt, but it's $75.00 per user per year and we have about 10 people here working with this stuff.

So I think I'll try the script route.

Thanks for all the help!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Encryption

From novice to tech pro — start learning today.