(Excel) Iterate Keys and Certs in PEM

Demonstrates how to access each of the private keys and certs contained within a PEM.

Download Excel Class Modules Chilkat Excel Class Modules

' Starting in v9.5.0.49, all Chilkat classes can be unlocked at once at the beginning of a program
' by calling UnlockBundle.  It requires a Bundle unlock code.
Dim chilkatGlob As Chilkat.CkGlobal
Set chilkatGlob = Chilkat.NewCkGlobal

success = chilkatGlob.UnlockBundle("Anything for 30-day trial.")
If (success <> True) Then
    Debug.Print chilkatGlob.LastErrorText
    Exit Sub
End If

' The Chilkat PEM class was introduced in v9.5.0.49.  
' It requires the bundle to be unlocked, as shown above.
Dim pem As Chilkat.Pem
Set pem = Chilkat.NewPem

' Load the PEM from a file.
' If the PEM is encrypted, provide a password.  Otherwise pass an empty string for the password.

password = "myPassword"
success = pem.LoadPemFile("../myPemFiles/myPem.pem",password)
If (success <> True) Then
    Debug.Print pem.LastErrorText
    Exit Sub
End If

' Note: If the app already has the PEM pre-loaded in a string variable, then load it 
' by calling LoadPem instead.  

pemContent = "... the PEM contents ..."
success = pem.LoadPem(pemContent,password)
' Check for success as before..

' Iterate over the private keys.

numPrivateKeys = pem.NumPrivateKeys

i = 0

Do While i < numPrivateKeys


    Set privKey = pem.GetPrivateKey(i)
    Debug.Print "Private Key "; i; " is "; privKey.BitLength; " in length"

    i = i + 1
Loop

' Iterate over the certificates.

numCerts = pem.NumCerts
i = 0

Do While i < numCerts


    Set cert = pem.GetCert(i)
    Debug.Print "Certificate "; i; " : "; cert.SubjectDN

    i = i + 1
Loop