(Excel) Load PEM and List Certificates

Demonstrates how to load a PEM containing certificates and accesses each individual certificate.

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

Dim pem As Chilkat.Pem
Set pem = Chilkat.NewPem

' Load the .p7b from a file.
success = pem.LoadPemFile("/Users/chilkat/testData/p7b/cacert_mozilla.pem")
If (success <> True) Then
    Debug.Print pem.LastErrorText
    Exit Sub
End If


numCerts = pem.NumCerts
If (numCerts = 0) Then
    Debug.Print (("Error: Expected the PEM to contain certificates."))
    Exit Sub
End If

' Access each certificate and show the Subject CN (Common Name)
For i = 1 To numCerts

    Set cert = pem.GetCert(i - 1)
    Debug.Print i; ": "; cert.SubjectCN

Next