(Excel) RSA Sign Using Private Key from .pfx/.p12 to Base64 Signature

See more RSA Examples

Demonstrates how to RSA sign something using a private key loaded from a .pfx/.p12. The RSA signature is returned in Base64 encoded format.

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim rsa As Chilkat.Rsa
Set rsa = Chilkat.NewRsa

' Load the .pfx/.p12
Dim pfx As Chilkat.Pfx
Set pfx = Chilkat.NewPfx

success = pfx.LoadPfxFile("qa_data/pfx/myKey.p12","myPassword")
If (success <> True) Then
    Debug.Print pfx.LastErrorText
    Exit Sub
End If

' Get the default private key.

Set privKey = pfx.GetPrivateKey(0)
If (pfx.LastMethodSuccess <> True) Then
    Debug.Print pfx.LastErrorText
    Exit Sub
End If

' Import the private key into the RSA component:
success = rsa.ImportPrivateKeyObj(privKey)
If (success <> True) Then
    Debug.Print rsa.LastErrorText

    Exit Sub
End If

' Get the signature in base64
rsa.EncodingMode = "base64"


strData = "This is the string to be signed."

' Sign the string using the sha256 hash algorithm.
' Other valid choices are "sha384", "sha512", "sha-1", "md2" and "md5".

base64Sig = rsa.SignStringENC(strData,"sha256")

Debug.Print base64Sig

Debug.Print "Success!"