[AccessD] Hashing and encryption in VBA using Next Generation Cryptography (CNG) API from Microsoft

Gustav Brock gustav at cactus.dk
Thu Apr 21 03:06:56 CDT 2022


Hi all

If you have a serious need for hashing or encryption using VBA and Microsoft Access/Excel, study my five-part article series:

Utilise Microsoft's Next Generation Cryptography (CNG) API in VBA
https://www.experts-exchange.com/articles/37111/Utilise-Microsoft's-Next-Generation-Cryptography-CNG-API-in-VBA.html?preview=/HbguS9iNco%3D

In addition to general hashing and encryption, it covers how to optimally handle passwords, meeting the extreme requirements for users' security and privacy.
Further, this is compatible with PowerShell and .Net, which allows for sharing hashed or encrypted data between the three environments.

Full code is on GitHub: 

VBA.Cryptography
https://github.com/GustavBrock/VBA.Cryptography.

/gustav


More information about the AccessD mailing list