(Excel) Load Java KeyStore and Access Contents

Loads a Java keystore file and iterates over the contents. A Java keystore (.jks) file can contain one or more trusted root certificate entries and/or one or more private key entries. Each private key entry includes an associated certificate chain.

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

' Load the Java keystore from a file.  The JKS file password is used
' to verify the keyed digest that is found at the very end of the keystore.
' It verifies there has been no tampering with the file.

success = jks.LoadFile("jksFilePassword","/someDir/keyStore.jks")
If (success <> True) Then
    Debug.Print jks.LastErrorText
    Exit Sub
End If

' Find out how many of each type of entry:

numTrustedCerts = jks.NumTrustedCerts

numPrivateKeys = jks.NumPrivateKeys

' For each trusted certificate, access it by getting
' it as a cert object.  Also get the alias associated with the certificate.
Debug.Print "Trusted Certs:"
i = 0
Do While i < numTrustedCerts
    Set cert = jks.GetTrustedCert(i)
    Debug.Print jks.GetTrustedCertAlias(i); ": "; cert.SubjectDN

    i = i + 1
Loop

' For each private key entry, get the private key and
' the associated certificate chain.
' Each private key is password protected.  Usually it is the same
' password as used for the keyed digest of the entire JKS.  
' However, this does not have to be.  The password is passed
' here to handle the possibility of each private key requiring
' a different password.
Debug.Print "Private Keys:"
i = 0
Do While i < numPrivateKeys
    Set privKey = jks.GetPrivateKey("jksFilePassword",i)
    Debug.Print jks.GetPrivateKeyAlias(i)
    Set certChain = jks.GetCertChain(i)

    ' The 1st certificate in the chain is the one associated with the private key.
    Set cert = certChain.GetCert(0)
    Debug.Print cert.SubjectDN

    i = i + 1
Loop