(Excel) Get Text Certificate Extensions by OID

See more Certificates Examples

Demonstrates how to get text certificate extensions by OID. In this example, we have a certificate with the following OID extensions: 1.3.6.1.4.1.49952.5.8.5, 1.3.6.1.4.1.49952.5.8.6, 1.3.6.1.4.1.49952.5.8.7.

Most certificate extensions have values that are ASN.1 (binary). For the majority of cases, an application should call GetExtensionAsXml. For extensions known to have text values (such as the OIDs listed above), an application can instead call GetExtensionAsText.

The GetExtensionAsText method is added in Chilkat v9.5.0.89.

Download Excel Class Modules Chilkat Excel Class Modules

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


success = cert.LoadFromFile("qa_data/certs/PUH9.cer")
If (success = False) Then
    Debug.Print cert.LastErrorText
    Exit Sub
End If


oid = "1.3.6.1.4.1.49952.5.8.5"

str = cert.GetExtensionAsText(oid)
If (cert.LastMethodSuccess = True) Then
    Debug.Print oid; ": "; str
End If

oid = "1.3.6.1.4.1.49952.5.8.6"
str = cert.GetExtensionAsText(oid)
If (cert.LastMethodSuccess = True) Then
    Debug.Print oid; ": "; str
End If

oid = "1.3.6.1.4.1.49952.5.8.7"
str = cert.GetExtensionAsText(oid)
If (cert.LastMethodSuccess = True) Then
    Debug.Print oid; ": "; str
End If