(Excel) Load Particular CA Certs into a Java KeyStore

Opens a PEM file containing many CA root certificates, and creates a Java keystore containing a subset of the certificates.

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim jks As Chilkat.JavaKeyStore
Set jks = Chilkat.NewJavaKeyStore

Dim troots As Chilkat.TrustedRoots
Set troots = Chilkat.NewTrustedRoots

' Load certificates from a file.

success = troots.LoadCaCertsPem("qa_data/curl_cacert.pem")
If (success <> True) Then
    Debug.Print troots.LastErrorText
    Exit Sub
End If

Dim sbDn As Chilkat.StringBuilder
Set sbDn = Chilkat.NewStringBuilder
Dim sbAlias As Chilkat.StringBuilder
Set sbAlias = Chilkat.NewStringBuilder

caseSensitive = False


i = 0

numCerts = troots.NumCerts

numAdded = 0
Do While (i < numCerts)

    Set cacert = troots.GetCert(i)
    sbDn.Clear 
    Dim success As Boolean
    success = sbDn.Append(cacert.SubjectDN)
    If (sbDn.Contains("Entrust.net",caseSensitive) = True) Then
        Debug.Print cacert.SubjectDN

        ' The alias is an arbitrary unique string for each cert in the JKS.
        sbAlias.Clear 
        success = sbAlias.Append("cacert_")
        success = sbAlias.AppendInt(i + 1)
        success = jks.AddTrustedCert(cacert,sbAlias.GetAsString())
        numAdded = numAdded + 1
    End If

    i = i + 1
Loop

' Verify the number of certs in the JKS equals the number we added.

numJksCerts = jks.NumTrustedCerts
Debug.Print "NumTrustedCerts = "; numJksCerts
If (numJksCerts <> numAdded) Then
    Debug.Print "Something is amiss!"
    Exit Sub
End If

' Save the JKS.
success = jks.ToFile("myPassword","qa_data/jks/entrust_caCerts.jks")
If (success <> True) Then
    Debug.Print jks.LastErrorText
    Exit Sub
End If

Debug.Print "Success."

' The output of this program when tested was:

' C=US, O=Entrust.net, OU=www.entrust.net/CPS incorp. by ref. (limits liab.), OU=(c) 1999 Entrust.net Limited, CN=Entrust.net Secure Server Certification Authority
' O=Entrust.net, OU=www.entrust.net/CPS_2048 incorp. by ref. (limits liab.), OU=(c) 1999 Entrust.net Limited, CN=Entrust.net Certification Authority (2048)
' C=US, O="Entrust, Inc.", OU=www.entrust.net/CPS is incorporated by reference, OU="(c) 2006 Entrust, Inc.", CN=Entrust Root Certification Authority
' NumTrustedCerts = 3
' Success.