(Excel) Convert ASN.1 to/from Binary DER, XML, and Base64

Demonstrates how to convert ASN.1 from and to any of the following formats: binary DER, Base64, and XML.

Download Excel Class Modules Chilkat Excel Class Modules

Dim asn As Chilkat.Asn
Set asn = Chilkat.NewAsn

'  Begin with loading ASN.1 from a binary DER/BER format file.
success = asn.LoadBinaryFile("/Users/chilkat/testData/p7b/test.p7b")
If (success <> True) Then
    Debug.Print asn.LastErrorText
    Exit Sub
End If

'  Convert ASN.1 to XML:

strXml = asn.AsnToXml()
If (asn.LastMethodSuccess <> True) Then
    Debug.Print asn.LastErrorText
    Exit Sub
End If

'  The XML returned by AsnToXml will be compact and not pretty-formatted.
'  Use Chilkat XML to format the XML better:
Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
success = xml.LoadXml(strXml)
'  Assuming success for this example..
'  This is formatted better for human viewing:
Debug.Print xml.GetXml()

'  Now get the ASN.1 in base64 format.  Any encoding supported
'  by Chilkat can be passed, such as "hex", "uu", "quoted-printable", "base32", "modbase64", etc.

strBase64 = asn.GetEncodedDer("base64")

'  Load the ASN.1 from XML:
Dim asn2 As Chilkat.Asn
Set asn2 = Chilkat.NewAsn
success = asn2.LoadAsnXml(xml.GetXml())
If (success <> True) Then
    Debug.Print asn2.LastErrorText
    Exit Sub
End If

'  Load the ASN.1 from an encoded string, such as base64:
Dim asn3 As Chilkat.Asn
Set asn3 = Chilkat.NewAsn
success = asn3.LoadEncoded(strBase64,"base64")
If (success <> True) Then
    Debug.Print asn3.LastErrorText
    Exit Sub
End If