(Excel) MD5 Hash a String (such as a password string)

Demonstrates how to MD5 hash a string to get MD5 hash in hex encoded string representation. (The MD5 hash is 16 bytes, and therefore a hex encoded MD5 hash would be 32 chars.)

Download Excel Class Modules Chilkat Excel Class Modules

password = "myPassword"

Dim crypt As Chilkat.Crypt2
Set crypt = Chilkat.NewCrypt2
crypt.HashAlgorithm = "md5"
crypt.EncodingMode = "hex"

md5Hex = crypt.HashStringENC(password)
Debug.Print "MD5 hash (as a hex string) = "; md5Hex

' The hex string will be uppercase.  Your application
' can easily convert it to lowercase if desired via non-Chilkat means.