If you are dealing with lots of data, especially if any of it is personal then you are going to need to make sure that you do everything you can to password protect and secure that data. For generating reports in Excel you might think that password protecting in Excel is good enough. From what I have been told even xlsx password protection is not that amazing.
As a result of the above I have looked into zipping a file and password protecting it. This seems like a more secure approach, after all it should also compress it making it easier to e-mail. Of course my preference is to store on a secure FTP or limited access shared drive but when needs must.
Using the code below, on Windows, seemed to do the trick. Will admit that when I was looking at this I did not realise that -p at the start of the password string was being ignored so the below actually makes the password, assword123. Amusing and probably more secure than password 123.
The code:
No comments:
Post a Comment