(Excel) Subject Alternative Name

Demonstrates the usage of the SubjectAlternativeName property to get the certificate SAN (subject alternative name) as XML.

Download Excel Class Modules Chilkat Excel Class Modules

' Note: Not all certificates contain a Subject Alternative Name.
' If it does not, the SubjectAlternativeName property will contain the empty string.

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


subjectAltNameXml = cert.SubjectAlternativeName

Debug.Print subjectAltNameXml

' Here's a sample of the subjectAltNameXml:

' <?xml version="1.0" encoding="utf-8"?>
' <SubjectAltName>
'     <name type="oid" oid="2.16.76.1.3.4">...</name>
'     <name type="oid" oid="2.16.76.1.3.2">...</name>
'     <name type="oid" oid="2.16.76.1.3.3">...</name>
'     <name type="oid" oid="2.16.76.1.3.7">...</name>
'     <rfc822Name>...</rfc822Name>
' </SubjectAltName>

' The XML can be parsed like this:

Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml

Dim success As Boolean
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]")
    i = i + 1
Loop

rfc822Name = xml.GetChildContent("rfc822Name")