(Excel) PKCS11 Find All Certificates on Smart Card or USB Token

See more PKCS11 Examples

Sample code showing how to examine all the certificates on a smart card or USB token.

Note: This example requires Chilkat v9.5.0.88 or later.

Download Excel Class Modules Chilkat Excel Class Modules

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' Note: Chilkat's PKCS11 implementation runs on Windows, Linux, Mac OS X, and other supported operating systems.

Dim pkcs11 As Chilkat.Pkcs11
Set pkcs11 = Chilkat.NewPkcs11

pkcs11.SharedLibPath = "aetpkss1.dll"


success = pkcs11.Initialize()
If (success = False) Then
    Debug.Print pkcs11.LastErrorText
    Exit Sub
End If

' We need to call Discover to get the slot ID.
' (A slot is a smart card reader or USB token.)

onlyTokensPresent = True
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = pkcs11.Discover(onlyTokensPresent,json)
If (success = False) Then
    Debug.Print pkcs11.LastErrorText
    Exit Sub
End If

' Make sure we have at least one slot.
If (json.SizeOfArray("slot") <= 0) Then
    Debug.Print "No occuplied slots."
    Exit Sub
End If

' Get the ID of the 1st slot

slotID = json.IntOf("slot[0].id")

' Open a session.

readWrite = True
success = pkcs11.OpenSession(slotID,readWrite)
If (success = False) Then
    Debug.Print pkcs11.LastErrorText
    Exit Sub
End If

' Make it an authenticated session by calling Login.
' 
' If we don't authenticate, then we won't be able to see the private keys, and thus
' we won't know which certificates have an associated private key stored on the smart card.

' The smart card PIN is passed to the Login method.
' userType 1 indicates a "Normal User".

userType = 1

pin = "0000"
success = pkcs11.Login(userType,pin)
If (success = False) Then
    Debug.Print pkcs11.LastErrorText
    success = pkcs11.CloseSession()
    Exit Sub
End If

' Call FindAllCerts to find all certificates on the smart card or USB token.
success = pkcs11.FindAllCerts()
If (success = False) Then
    Debug.Print pkcs11.LastErrorText
    success = pkcs11.CloseSession()
    Exit Sub
End If

' The NumCerts property is set by FindAllCerts.

numCerts = pkcs11.NumCerts
Debug.Print "Number of certs: "; numCerts

Dim cert As Chilkat.Cert
Set cert = Chilkat.NewCert

i = 0
Do While i < numCerts
    Dim success As Boolean
    success = pkcs11.GetCert(i,cert)
    privateKeyNote = ""
    If (cert.HasPrivateKey() = True) Then
        privateKeyNote = "(has private key)"
    End If

    Debug.Print i; ": "; privateKeyNote; " "; cert.SubjectDN
    Debug.Print i; ": issuer: "; cert.IssuerDN
    Debug.Print "----"
    i = i + 1
Loop

' Revert to an unauthenticated session by calling Logout.
success = pkcs11.Logout()
If (success = False) Then
    Debug.Print pkcs11.LastErrorText
    success = pkcs11.CloseSession()
    Exit Sub
End If

' When finished, close the session.
' It is important to close the session (memory leaks will occur if the session is not properly closed).
success = pkcs11.CloseSession()
If (success = False) Then
    Debug.Print pkcs11.LastErrorText
    Exit Sub
End If

Debug.Print "Success."