(Excel) Subject Alternative Name for ICP Brasil Certs

Demonstrates how to access the multiple names contained in the Subject Alternative Name of a certificate. This example is for an ICP Brasil certificate.

For more information, see http://oidref.com/2.16.76.1.3

Download Excel Class Modules Chilkat Excel Class Modules

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


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

' If the cert's Subject Alternative Name contains multiple values, each specified by an OID,
' then the Rfc822Name property returns XML.

subjectAltNameXml = cert.Rfc822Name

Debug.Print subjectAltNameXml

' Here's a sample of the subjectAltNameXml:

' <SubjectAltName>
'     <name type="oid" oid="2.16.76.1.3.4">290999653223955019700000000000000000000150424SRJUXPTS</name>
'     <name type="oid" oid="2.16.76.1.3.2">JOAO SILVA</name>
'     <name type="oid" oid="2.16.76.1.3.3">02408939000115</name>
'     <name type="oid" oid="2.16.76.1.3.7">000000000000</name>
' </SubjectAltName>

' The XML can be parsed like this:

Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
success = xml.LoadXml(subjectAltNameXml)


i = 0

count_i = xml.NumChildrenHavingTag("name")
Do While i < count_i
    xml.I = i
    oid = xml.ChilkatPath("name[i]|(oid)")
    name = xml.GetChildContent("name[i]")
    Debug.Print oid; ": "; name
    i = i + 1
Loop