(Excel) Encrypt / Decrypt Secure Strings

Demonstrates how to use the EncryptSecureENC and DecryptSecureENC methods to encrypt/decrypt secure strings. These methods were added in Chilkat v9.5.0.71 (released January 2018).

Download Excel Class Modules Chilkat Excel Class Modules

'  This example requires the Chilkat Crypt API to have been previously unlocked.
'  See Unlock Chilkat Crypt for sample code.

'  Load the secure string with some text.
Dim secStr1 As Chilkat.SecureString
Set secStr1 = Chilkat.NewSecureString

success = secStr1.LoadFile("qa_data/txt/helloWorld.txt","utf-8")
If (success <> True) Then
    Debug.Print "Failed to load helloWorld.txt"
    Exit Sub
End If

Dim crypt As Chilkat.Crypt2
Set crypt = Chilkat.NewCrypt2

crypt.CryptAlgorithm = "aes"
crypt.CipherMode = "cbc"
crypt.KeyLength = 128
crypt.SetEncodedKey "000102030405060708090A0B0C0D0E0F","hex"
crypt.SetEncodedIV "000102030405060708090A0B0C0D0E0F","hex"
crypt.EncodingMode = "base64"

'  Return the base64 encoded encrypted contents of secStr1.

encryptedStr = crypt.EncryptSecureENC(secStr1)
Debug.Print "Encrypted string: "; encryptedStr

'  Output:
'  Encrypted string: qiq+IFhcjTkEIkZyf31V/g==

'  Decrypt to secStr2:
Dim secStr2 As Chilkat.SecureString
Set secStr2 = Chilkat.NewSecureString
success = crypt.DecryptSecureENC(encryptedStr,secStr2)

'  Access the contents of secStr2
Debug.Print "Decrypted string: "; secStr2.Access()

'  Output:
'  Decrypted string: Hello World!