(Excel) Add S/MIME Signature using PFX

Add a digital signature to a MIME message using the certificate + private key from a PFX file.

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim mime As Chilkat.Mime
Set mime = Chilkat.NewMime

' Load a PFX file into a certificate object.
Dim cert As Chilkat.Cert
Set cert = Chilkat.NewCert

pfxFilepath = "pfxFiles/something.pfx"

pfxPassword = "secret"

success = cert.LoadPfxFile(pfxFilepath,pfxPassword)
If (success = False) Then
    Debug.Print cert.LastErrorText
    Exit Sub
End If

success = mime.SetBodyFromPlainText("This is the plain-text MIME body.")

mime.Charset = "utf-8"
mime.Encoding = "quoted-printable"

' Sign the MIME (adds a PKCS7 detached signature)
success = mime.AddDetachedSignature(cert)
If (success = False) Then
    Debug.Print mime.LastErrorText
    Exit Sub
End If

' Save the S/MIME to a file.
success = mime.SaveMime("/temp/signedMime.txt")
If (success = False) Then
    Debug.Print mime.LastErrorText
    Exit Sub
End If

Debug.Print "success!"