How do you encrypt a file.

[ToyFox]

We have been faxing a list to a vendor, this has to change, and I must create a file that is encrypted. How do I encrypt a file. Thx

 

[macropod]

Carefully.

There are many encryption methods available, with varying levels of security. A web search for 'vba encryption algorithm', for example, will soon turn up many vba implementations.


Cheers
[MS MVP - Word]

 

[ToyFox]

thanks much

 

[strongm]

Or you could just use the built-in encryption in Windows, which supports things such as AES/Rijndael

 

[TonyJollans]

If you're creating an Office document (which, presumably, you are as you are asking about VBA) the built-in facilities in Office should do the trick. It has some weaknesses in 2003, but encryption of 2007-format documents with 2007 SP2 is pretty solid. It uses AES by default but does it all through standard Windows facilities which allow you to use your own encryption provider if you want or need to.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website