(Excel) Convert Java KeyStore to PEM

Loads a Java keystore file and saves the trusted certificate entries to a PEM file.

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


jksPassword = "myJksPassword"

' 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 that the keystore has not been modified.

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

' Open/create the output PEM file. 
' This example uses Chilkat's file access class for writing the output file.
' You may replace the file I/O lines of code with whatever is most convenient for you.
Dim fac As Chilkat.FileAccess
Set fac = Chilkat.NewFileAccess
success = fac.OpenForWrite("/pemFiles/caCerts.pem")
If (success <> True) Then
    Debug.Print fac.LastErrorText
    Exit Sub
End If


numCerts = jks.NumTrustedCerts

' Iterate over the trusted certs, get the PEM for each,
' and append it to the output file.
i = 0
Do While i < numCerts
    Set cert = jks.GetTrustedCert(i)

    ' Get the certificate in PEM format.  
    pem = cert.ExportCertPem()

    ' Append the PEM string to the open file.
    ' The PEM contains only us-ascii chars..
    success = fac.AppendAnsi(pem)
    If (success <> True) Then
        Debug.Print fac.LastErrorText

        Exit Sub
    End If

    i = i + 1
Loop

' Close the output file.
fac.FileClose 

Debug.Print "Trusted certificates saved to PEM."