A code to create a file that is password protected

[charlie727]

Hi all,

I'm looking to try and create a code that will create a new excel file and add a password to that file known only to me.

I'm creating files on a public server at work and I know how to protect the code from being seen but not the file I create from being seen. Is there anybody that can help please?

Thank you for your time

Charles