(Excel) Load Certificate from PFX (PKCS#12)

Loads a digital certificate (and private key, if available) from a PFX file.(also known as PKCS#12)

Download Excel Class Modules Chilkat Excel Class Modules

Dim cert As Chilkat.Cert
Set cert = Chilkat.NewCert

' Load from the PFX file

pfxFilename = "/Users/chilkat/testData/pfx/chilkat_ssl_pwd_is_test.pfx"

pfxPassword = "test"

' A PFX typically contains certificates in the chain of authentication.
' The Chilkat cert object will choose the certificate w/
' private key farthest from the root authority cert.
' To access all the certificates in a PFX, use the 
' Chilkat certificate store object instead.
success = cert.LoadPfxFile(pfxFilename,pfxPassword)
If (success <> True) Then
    Debug.Print cert.LastErrorText
    Exit Sub
End If

' Get some information about the digital certificate, 
' then get the private key...

' DN = "Distinguished Name"
Debug.Print "SubjectDN:"; cert.SubjectDN

Debug.Print "Common Name:"; cert.SubjectCN
Debug.Print "Issuer Common Name:"; cert.IssuerCN

Debug.Print "Serial Number:"; cert.SerialNumber

' Now for the private key...

Set privKey = cert.ExportPrivateKey()
If (cert.LastMethodSuccess = False) Then
    Debug.Print cert.LastErrorText
    Exit Sub
End If

' The private key object may be used in any Chilkat methods
' (in other objects/classes) that expect a private key argument.

' In this case, save the private key to a PKCS8 Encrypted PEM format file:

pemPassword = "secret"

pemPath = "/Users/chilkat/testData/pem/chilkat_privKey.pem"
success = privKey.SavePkcs8EncryptedPemFile(pemPassword,pemPath)
If (success <> True) Then
    Debug.Print privKey.LastErrorText

    Exit Sub
End If

Debug.Print "Private key saved to PKCS8 Encrypted PEM..."