(Excel) Load Certs from Java KeyStore into Trusted CA Roots

Demonstrates how to load a Java KeyStore containing CA root certificates that are to be trusted by the application. This can be done once at the beginning of an application, and then the trusted roots can be activated so that only these root CA certs are trusted by the application for any TLS connections.

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
jks.VerboseLogging = True


password = "myPassword"

success = jks.LoadFile(password,"qa_data/jks/entrust_caCerts.jks")
If (success <> True) Then
    Debug.Print jks.LastErrorText
    Exit Sub
End If

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

success = troots.AddJavaKeyStore(jks)
If (success <> True) Then
    Debug.Print troots.LastErrorText
    Exit Sub
End If


i = 0

numCerts = troots.NumCerts
Do While (i < numCerts)

    Set cacert = troots.GetCert(i)
    Debug.Print i; ": "; cacert.SubjectDN

    i = i + 1
Loop

' Activate this specific set of trusted roots.
success = troots.Activate()
If (success <> True) Then
    Debug.Print troots.LastErrorText
    Exit Sub
End If

' Output:

' 0: 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
' 1: 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)
' 2: C=US, O="Entrust, Inc.", OU=www.entrust.net/CPS is incorporated by reference, OU="(c) 2006 Entrust, Inc.", CN=Entrust Root Certification Authority